Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Looking for a record
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00111724
Message ID:
00117299
Vues:
33
Thanks guys for the advise and help!

I ended up making a form and experimenting some...
1 table, 100,000 records, 19 fields (1 integer, 17 character, 1memo)...
1 form (1 command button, 1 txtBtns button bar, 1PageFrame, 6 pages - 5 pages averaged 12 fields each, 6th page had a grid)

At the start my search times were around 10-15 seconds....way too long.

I modified the SearchForm class (in my local copy of WizStyle.vcx), commenting out each line that said "SET FILTER TO something"...... but nothing changed !?!?!?

I stepped through the execution and...when it got to the line that said
SET FILTER TO &cGetExpr
My commenting out was not there!!

Question: What happened? I even reloacted all VCX's except those in the local directory...which I was altering... oh well.

Conclussion:
I copied the SearchForm class to my vcx, renamed it, modified it (commenting out the filter stuff), and altered my find code to refer to the re-named class.

Finally. Success! My find now runs fast enough to make the REFRESH the slow part of it all.

Again,
Thanks guys for the advise and help!

--------------------------------------------------------------

>>The tables I'll be searching are around 75,000 records and 15MB in size ...
>>
>>I want similar functionality to the find button found in the VFP WizStyle.VCX >txtbtns class. I'd use that one but it is based on filters and locate. As a >result it is incredibly SLOW!!!
>
>LOCATE speed should not be a problem if it is properly optimized. But filters are a different story. But if you end up using filters with large data sets, one tip is to use LOCATE instead of GO TOP (difference between fraction of a second for LOCATE and several minutes for GO TOP).
>
>>If you have any code, classes, downloads, or 3rd party ideas....
>
>Check out QBF (Query By Form) Builder (search the libraries for 'QBF'). Drop a QBF control on your form, run the builder, pick your query fields, and run!
>
>QBF Builder works with tables, and local/remote views; and also has a 'custom' style.
>
>Here is a simplified example of what the code would look in your toolbar button's click:
>
>IF TYPE('_Screen.ActiveForm.cmdQBF.Name') = 'C'
> _Screen.ActiveForm.cmdQBF.Click
>ENDIF
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform