Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data Access Speed
Message
De
24/06/2003 11:58:19
 
 
À
24/06/2003 09:55:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00803166
Message ID:
00803332
Vues:
7
WOW... you probably don't even need CDXs on THAT config < s >! I suppose it's running SCSI RAID 5 too.



>I've had SQL 2000 running on lesser servers. A server with Two 1.6 Gig processors and 2 gigs of RAM that has 30 users accessing VFP tables. Nothing else is on the server. The server has a GigaBit connection to the Gigabit switch. The largest table has less than 50,000 records and only 20 fields.
>
>I am still cleaning up indexing but I just want to eliminate any possible reasons for speed problems.
>
>
>
>>I'd say it shouldn't be a problem if the file server has lots of RAM (and is not peer-to-peer).
>>
>>I guess there can be instants when something may be noticed, depending on how much data is pulled for the ACCESS reporting at any given time.
>>
>>
>>
>>>I have a client with a VFP 6.0 app. The tables are also being accessed via MS Access for reporting. Will MS Access affect the speed of VFP accessing the data? The tables are all free tables if that makes a difference.
>>>
>>>Help is appreciated.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform