Information générale
Catégorie:
Bases de données
Versions des environnements
Network:
Windows 2003 Server
>Thanks Suhas. We did that and yes, it is similar. I had a difficult time explaining to the net programmers why I can open the tables across the T1 and browse them instantaneously and step through the records et al (like the old VFP app does) but the queries from net are so slow. Programmers that have never used VFP don't get the data engine and are amazed at VFP's ability to crunge data. Most just don't know I've found out and assume it is an old language not worth considering. I am surprised at the number of 3rd party apps out there using VFP tables that I seem to have to integrate with every year. The nice thing about VFP is we can check to ensure the query is optimized. Is there a similar function in net to sys(3054,11)? Probably not, since VFP controls the tags and it is internal to VFP. Would be nice though. We got it down to anywhere from 1 sec to 1 minute 30 seconds. We have to keep the time under 20 secs though so we are requesting from the holder of the data
>permission to install a webservice on their server and to create our own tags for optimization of our queries. The data is in old FPW tables surprisingly.
>
>
>>>Foxpro tables exist across a T1 link. Using a winform (for testing but it will be a process on the server) in vb.net and OLEDB to ADO to grab data from vfp tables. Very slow. Recommendations? The best way to handle it?
>>>
>>>Using the version 8 oledb driver.
>>
>>
>>Hi,
>>1 Suggestion,
>>Check using VFP + Oledbdriver. Is the time to fetch the data same ?
>>
>>Suhashegde
I have not tried this But There could be 1 possiblity of attaining speed In case the tables are compatible with VFP6(I use VFP6 not sure of the later versions if they have or ship the dll)
Remember fpole.dll ??
That would just add a good speed to you product i feel just as though you will be working with VFP.
Just try, No harm in trying
Suhashegde
P.S.:Incase you succeed Also please let me know....
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