Hello people,
I might sound a little bit crazy, but is there any possibility that you can incorporate 1,073,741,824 tables into a SQL Database?
I mean, is it possible at all? There might be a question of where anyone would want so many tables, but i'm a bioinformatics guy and I'm trying to deal with genomic sequences and was coming up with a new algorithm, where the only limit is the number of tables I can put into a Database.
So, can you please advise if its possible to put in so many tables into a SQL database? Or is the Bekerley DB better?
SQL Server DB forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1) might be better for such questions.
According to http://msdn2.microsoft.com/en-us/library/ms143432.aspx, there is a limit of 2^31 or 2,147,483,647 on the total number of objects in the database, including tables, views, etc. It is less than your requirement, but close.
I would discuss this design however at the forum above - I suspect the problem can be solved more effective in a different way.
No comments:
Post a Comment