Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Going from Oracle 8 to Oracle 11 huge slowdown
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Going from Oracle 8 to Oracle 11 huge slowdown
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01614550
Message ID:
01614550
Views:
42
I have a VFP 9 app that uses remote views to connect to an Oracle backend. When I run my app against the 8i database - it works just fine. If I try to use the 11G backend - a query that takes no time under 8i takes like 6 to 10 seconds under 11G. What is odd is that if I use a tool like TOAD to run the querry it works really fast - but if I do it via ODBC it takes forever. I've tried the Oracle version 10 ODBC drivers and the version 11 ODBC drivers and get same problem with both. I've talked to our Oracle DBA and he can run the select statements on the backend and they work as they should. I'm really kinda lost here - anyone have any suggestions? I can't really release my app update if it takes 2 minutes for a screen to pop up..ahhh!
ICQ 10556 (ya), 254117
Next
Reply
Map
View

Click here to load this message in the networking platform