December 2, 2011 at 12:06 pm
can sql server manage easly millions of rows in a table that has columns for let's say 2 bytes each row
but about hundreds of millions of rows?
December 2, 2011 at 12:22 pm
The short answer is "Yes, SQL Server is designed for that sort of thing." The long answer is "It depends."
It depends on what edition of SQL Server you are using, what kind of hardware you have, how much RAM you have, number and speed of CPU's, I/O performance and more. Oh, it also strongly depends on the quality of your database design and application design. If, for example, your application uses only T-SQL cursors for database access, then it is probably going to choke on anything more than a few million records.
Performance also depends on other things, like concurrency. So, your question is a little broad to answer easily. If, however, you want to know if SQL Server will perform as well as other major Relational Database Management Systems (all other things being equal) then the answer is, yes - the performance will be comparable.
Not sure if this helps. If it doesn't, try narrowing the focus of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply