Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Proble with INSERT SQL
Message
From
16/10/1997 04:14:45
Nico Grilli
Spark Consulting Srl
Corato (Ba), Italy
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Proble with INSERT SQL
Miscellaneous
Thread ID:
00054820
Message ID:
00054820
Views:
73
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
Next
Reply
Map
View

Click here to load this message in the networking platform