soclose
August 12th, 2008, 02:53 AM
Hi All. Is there any article that describe the main ideas how to make Database design holding 100,000 records per table? If so, pls share to me. Thanks.
Click to See Complete Forum and Search --> : How to handle 1 00, 000 records per table?
HairyMonkeyMan
August 12th, 2008, 07:09 AM
Which dbms are you using?
How many fields are there?
This shouldn't be a problem for any dbms.
How many fields are there?
This shouldn't be a problem for any dbms.
soclose
August 28th, 2008, 02:29 AM
Hi it is Microsoft SQL Server 2005. It may have 20 fields per table. thks.
davide++
August 28th, 2008, 03:28 AM
Hi all.
As HairyMonkeyMan said 100,000 records aren't a big number for any database (I'm working on databases that have million of records).
Anyway, it's important to locate primary keys and indexes correctly, in order to make queries faster.
As HairyMonkeyMan said 100,000 records aren't a big number for any database (I'm working on databases that have million of records).
Anyway, it's important to locate primary keys and indexes correctly, in order to make queries faster.
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.
Copyright Internet.com Inc., All Rights Reserved.