Slow ODBC Access Across Network

[johnmiller1950]

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

[bangkok]

Wich database are you using ?

And which ODBC driver ?

Which data source, user or system ?

Personally, i use ODBC, from several PC, with :

-a FileMaker pro Server. With Datadirect SequeLink 5.5 (the one provided with FM) : no problem
-a MS SQL server : no problem