Information générale
Titre:
Any Experience with SQL Server 2000 speed ?
Hello all,
Due to 2GB limitation of VFP we moved our database to SQL Server 2000.
Our applications handle large data volumns of about 5,000,000 incoming records per week which we have to load them Validate them (with very complex statistical algorithms) and Process them.
In order to apply these algoritms you need record by record scans, SQL statemnts, loops, if statements, temporary cursors etc.. (all the VFP good commands) You cannot avoid them !!!
We started writing SQL server SP to handle these algoritms but we find out we cannot reach VFP times.
Now we are thinking to leave the database in SQL Server and validate / process the data, with VFP COM object which will extract based on filter the data need to process and update back the final results to SQL Server.
Any ideas will be very helpful
Thanks in advance
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