Versions des environnements
>>
>>I've profiled the program and 95% of all the time taken is in that write to table/fpt command, is there anything I can do?
>>
>>
>>Ken.
>
>Any chance of using SQL Server or SQL Express as the datasource? Then you could do the work in an SP on the server which would probably be MUCH faster..
I've got mysql server running on the processing machine, but using that to store the data would mean rewriting the sorting and matching part of the program, which is a lot of code and is currently fast, getting the data from memory back onto disk as a foxpro table is the bit that is slow. once I've got that bit done it sorts and matches in seconds and then writes out to a pipe delimited file in seconds.
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