Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Proble with INSERT SQL
Message
De
16/10/1997 04:14:45
Nico Grilli
Spark Consulting Srl
Corato (Ba), Italie
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Proble with INSERT SQL
Divers
Thread ID:
00054820
Message ID:
00054820
Vues:
78
i have a great problem with buffering of row,
i use a view that update a table with row buffering,
my program exec a series of insert sql on the table,
if that program run alone the performance is like a direct insert on the table
but if that program run on two or more istances the performance
drop down seriously and on the bar stat of a windows i can read "Attemping to lock..."

i don't understand why is necessary a lock if an insert lock only the header
and the table is open in shared mode.

can you help me?
it's a serious problem because the performance in shared access are compromised.

thanks,
Nico Grilli
nicogr@tin.it
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform