Re: High Throughput Database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

First column.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Derek Hart" <derekmhart@xxxxxxxxx> wrote in message news:%23cHOOIo4JHA.1432@xxxxxxxxxxxxxxxxxxxxxxx
Can you tell me what you mean by the high-order column?

"Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:ehXmani4JHA.1712@xxxxxxxxxxxxxxxxxxxxxxx
I think 3 tables will provide the same performance as one set per user as long as UserID is the the high-order column of each index. Millions of rows isn't really that large nowadays with a properly indexed tables.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Derek Hart" <derekmhart@xxxxxxxxx> wrote in message news:eQsNAai4JHA.1196@xxxxxxxxxxxxxxxxxxxxxxx
I have a database system that saves tons of data per user, in a web database system. Each user could have 10,000 - 20,000 records. This is going to be used potentially by thousands of users, so the numbers head into the millions of records very quickly. There are only 3 tables that need this kind of storage, so I was considering having a new set of these 3 tables made on the fly as each new user joins. I was considering even making a new database per user. But that I come back to using the 3 tables for everybody, because the indexing has been well tested with millions of records. Any creative ideas on this? 10,000 users would potentially create 30,000 tables, so that's seems like a bit of a nightmare. Perhaps go a different route and learn about load balancing, and how the sql server pooling will work. Please give me your thoughts, especially if you have created web sites and database connectivity at this level.





.

Relevant Pages

  • Re: High Throughput Database
    ... I mean the first column of the indexes. ... Dan Guzman ... SQL Server MVP ... I was considering even making a new database per user. ...
    (microsoft.public.sqlserver.programming)
  • Re: last
    ... Comparing with the max of a Non-Unique column might return more than ... "Dan Guzman" wrote in message ... > relational and are not implemented in SQL Server. ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Is it possible to write and add in to sql server analyzer?
    ... "Dan Guzman" wrote in message ... > You an define an external application to Query Analyzer under Tools --> ... > SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Backup to another drive
    ... Andrew J. Kelly ... SQL Server MVP ... "Dan Guzman" wrote in message ... > SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: more service pack question
    ... It is in the directory for the SQL Server program files. ... Tibor Karaszi, SQL Server MVP ... >> Dan Guzman ...
    (microsoft.public.sqlserver.security)