General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Performance quandry, a better way to update
I have a barcode data collection system written in foxpro. I am feeding data to a canned business system. The business system has a posting program that posts data from my table into it's own tables. The problem is; the posting program requires exclusive use to purge out the records. Unless the program can get exclusive use of the table, nothing gets posted.
So, in my collection system I open the table like:
use 'bcexclusive' in 0 shared
*then I add to the table using the insert function
Insert into 'bcexclusive'..... etc
use in 'bcexlusive'
The employee may make 1 entry or 10 entries and each time the table is opened and closed. That table gets opened and closed over 1000 times a day.
Is there a better way?
I seem to have a bottle neck somewhere slowing things down, I think this it.
agree? disagree?
I considered leaving it open and periodically closing the table, say every 2 hours, but all the workstations would have to be synchronized. Seems to be a complicated solution. Perhaps there is a better way.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only