Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How much of a slow down do indexes cause?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
How much of a slow down do indexes cause?
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01578310
Message ID:
01578310
Vues:
62
Hi everyone,

Hey, I've been coding in VFP now since 94 and I know how I would answer this question but I wanted to ask some other gurus.

For a VFP free table that has over 100,000 records in it with 29 existing indexes, we are considering adding 5 more index tags but have some concerns that this may cause more slow down when new records are added than it does now. Our application is running on a beefy machine but has 50+ users hitting it.

Would 5 more indexes probably cause any noticeable difference?

Thanks for your input!
Kevin Scott
kehvn@carolina.rr.com


Hey! It's not my fault. It's some General named Protection!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform