Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Jim -
Thanks for the reply
You wrote:
I ASSuME that when you say "large data file sets" you mean large .DBF/.CDX tables.
Reply: Yes
You wrote:
What is/are the larger and more heavily used tables and what exact index TAGs are defined in each?
Reply: the tags are exactly as that of the index names
You wrote:
Do your WHERE/FOR etc. clauses have expressions coded that match the TAG declarations exactly, as required for Rushmore to operate?
Reply: Yes
You wrote:
Are the multi-users all using some 'proper' network/file-server OS, as opposed to WinXX peer-to-peer?
Reply: They are using Windows NT, each ws is one of the Windows OS
You wrote:
Does the application use lots of SQLs or LOCATEs or SCANs. If so, which?
Reply: Mainly Seek(alltrim(xxx)), as well as Locates (indexes have been switched off when doing locates), some do while, no scans
You wrote:
Are you deliberately locking records or are you leaving tht to VFP to handle?
Reply: Letting VFP handle it
You wrote:
What type of buffering/locking is in use in the application?
Reply: Optimistic record
I thought as much, when we run it here in our NT environment, it seems to process quite well, however, we do not have as many users as our user. Nor as many records. The largest record set of 888K
Thanks,
Larry
Précédent
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