Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Well, as I said I made some costmetic changes of the code during posting. Sorry, shouldn't have done this. To be more precise I exchanged the hard coded values 2005 and 1 with the vars. If you fix the code it does updates.
And all in all it's slower than the sql, although I was lucky (or unlucky), that the xbase code ran faster in the two test calls I only did.
The time needed by either sql or xBase varies very much. Taking 2 to 14 seconds with sql and 3 to 50 seconds with xBase on a 1Ghz PIII notebook with 128 MB ram and 40GB HDD. In My first testruns I got some of the best xCase running times and about 2-3 times slower SQL running times.
Now, as I did some more test runs I'd also concratulate to SQL. Maybe the xCase variant can be optimized a little further if I analyize it with COVERAGE. Just for the fun of it...
Bye, Olaf.
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