> I'd have to question any design for a database that requires half a million
> tables. Point of fact, I can't imagine any circumstances when that number of
> tables would be required.
>
One possible case could be if they are porting an SQL Server app
that (most certainly) creates a lot of temporary tables during the
normal course of operation. If the app does, and they expect a lot
of concurrent users, 500,000 tables doesn't sound all that
unimaginable... Having, say, 50 temp tables created dynamically
per session, they only need 10,000 concurrent users to achieve their
goal (that's not counting permanent tables they will surely have.) :)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Fri Dec 20 2002 - 02:21:02 CST
