Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
If I have more records, are my queries slower?
Hi, all!
I have a general question for the crowd:
Let's say I have 10 million records in an inventory table with an indexed field on part number. We have a related table of 10,000 different parts.
If I SQL-Select things from the inventory with:
SELECT * FROM inventory WHERE partno = 54321 INTO CURSOR cTemp
the select will take a small amount of time.
Now, let's say we archive off 5 million records (and pack!) the inventory table. Now, only 5,000 different parts are in the inventory table, because we archived off records for the other 5,000.
My question: "Would you expect SQL-Selects by part number from the 5 million record table to be faster or slower, and why?"
The reason I'm asking is that we have a client who wants to split their large tables in two for speed reasons.
Thanks.
- George
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement