Slow ODBC Access Across Network
Posted: Wed May 11, 2011 1:04 pm
Greetings All,
I am trying to access the purchase history of inventory from an OBDC compliant database located on a server.
If I place the database on my computer, livecode will access the database and return the information in less than a second.
However, when the database is on the server, the same search takes 45 seconds.
If I try to cross reference two databases to pull out the history of a particular item, livecode can do it in about 6 seconds when the database is on the local computer. If I try the same thing on the server, it takes so long that livecode freezes up and becomes unresponsive.
A couple years ago, this function worked extremely well. Something has changed, and I'm not sure what. I have updated RunRev & LiveCode numerous times, windows is constantly updating, and the program that creates the database has been updated, although I have their latest OBDC driver.
I might mention that the database in question has 33,000 records.
Has anyone else run into a similar problem?
Thanks for your help.
John Miller
I am trying to access the purchase history of inventory from an OBDC compliant database located on a server.
If I place the database on my computer, livecode will access the database and return the information in less than a second.
However, when the database is on the server, the same search takes 45 seconds.
If I try to cross reference two databases to pull out the history of a particular item, livecode can do it in about 6 seconds when the database is on the local computer. If I try the same thing on the server, it takes so long that livecode freezes up and becomes unresponsive.
A couple years ago, this function worked extremely well. Something has changed, and I'm not sure what. I have updated RunRev & LiveCode numerous times, windows is constantly updating, and the program that creates the database has been updated, although I have their latest OBDC driver.
I might mention that the database in question has 33,000 records.
Has anyone else run into a similar problem?
Thanks for your help.
John Miller