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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only