Maximum tables in a database?
I wonder how many tables is the maximum for a normal linux server? Let's say we put's a multiuser phpnbb forum with 2000 users with a set of 20 tables per user. This means 20 000 tables. If the admin for each table opens each forum at the same time, I imagine that like 5 table files per forum has to be opened equal to 100 000 files at the same time. As fare as I know a linux kernel kan work with no more than 1024-2048 native threads at the same time. This can be increase to 4048, but it will newer come close to the 100 000 files needed to be opened?
My question is therefore, in reality, how many tables in a database is realistic?
Subject
Views
Written By
Posted
Maximum tables in a database?
2913
November 06, 2005 08:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.