alex hall wrote:
> Hi
>
> Now I am wondering if this is wise, as the
> database now consists of over 1,400 tables and new
> ones being created hourly. Is there an upper limit
Are you wondering if it is wise, or are you maybe thinking that it was probably not so wise ;-)
> would provide the better solution? Are the issues
That's easy. One table fits all.
> with this type of design?
Yes, lots! instead of maintaining jus one table, you need to maintain thousands...and counting. That means that any optimization or extension you can think of needs to be pushed to all these tables.
I don't know if there are any physical reasons that would stop you from doing this.
Check out this blog:
http://bobfield.blogspot.com/2006/03/million-tables.html