Information générale
Catégorie:
Codage, syntaxe et commandes
>When set exclusive in on, my SELECTS execute almost exactly
>10 times faster than with the tables opened shared Why? I want the speed, but need to share as well.
>
>I ran a program to try about 30 equal size selects, ran this
>with exclusive on and off and the results averaged about 0.7 sec with exclusive (max 1.7 min .49). With shared it averaged about 7 sec (max 25 sec, min .89 sec). What's going on?
if the files are used EXCLUSIVEly fox just locks the whole table
but if the use is SHAREd it has to lock each record when he reads it
this is btw, one of the reasons that sometimes it is faster to
"take apart" an SQL statement to several queries
Arnon
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