Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow SQLEXEC
Message
From
28/08/2003 16:05:24
Jonathan Cochran
Alion Science and Technology
Maryland, United States
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Miscellaneous
Thread ID:
00824258
Message ID:
00824354
Views:
20
I would doubt it. We require at least MDAC 2.6 SP1, and I doubt they have anything else on their machine that would have put a newer version on (they have newer Windows 2000 machines, and don't have much installed other than our software). I'll check, though.

Thanks,
Jonathan

>Do the machines that are causing the problem have different ODBC drivers from the rest?
>
>
>>We are accessing an Oracle 9i database using Microsoft's ODBC driver for Oracle. We use SQL-Passthrough to download the data we need from the server. On a couple machines (which are on the same network), one particular SQLEXEC statement is taking an extraordinarily long time to run. This same statement has run reasonably fast before on those machines. The SQLEXEC in question is downloading from a table which has a VARCHAR2(2000) field, which obviously gets converted to a memo field on the local cursor. There is a wide variety of data in this field, from a few characters to 1500 characters. The two machines that have this problem connect to a server that few other people connect to, so it makes it hard to determine if this is a problem with the server or those two clients.
>>
>>I'm kind of leaning towards a problem with the network that these two machines are on, since we have had other users connect to another server and download a lot more data than what these two users are having a problem with. I'm going to see if they can move one of their machines onto the same network that the server is on to see if the problem still exists. I was curious though if anyone else has seen similar problems in the past and could possibly suggest other things to look at other than network problems.
>>
>>Thanks,
>>Jonathan Cochran
Previous
Reply
Map
View

Click here to load this message in the networking platform