Hi All,
I have a customer using my program on Windows 7 64bit (with the 32 bit 11g client.) It was created with ODAC version 6.90.0.55 under D2010. Are there any known issues with that configuration? They are seeing very slow queries, that take exponentially more time as the number of rows increase. I'm using TOraQueries mostly with Unicode OCI calls on (although turning it off didn't seem to change anything.) The same program under Win 7 32bit doesn't seem to have a problem at all. I suspect that it's a configuration thing, but I'm not sure what to suggest to fix it.
Any suggestions are greatly appreciated!
-Mark Ford
Benthic Software
Are there any performance issues under Windows 7 64bit?
We have never heard about any performance issues under Windows 7 64bit. Maybe it depends on queries.
Try to turn off all firewalls and other programs that check TCP/IP traffic. They can cause slow query execution.
If this method doesn't help to resolve your issue then try to find queries that are executed slowly and execute them in the SQL Plus utility. If the queries will be executed slowly in the SQL Plus utility then this is a performance problem in the Oracle client and you should ask the Oracle company for help. If queries are executed quickly in the SQL Plus utility then, please, send us the text of these queries. Also we need a DDL script to create tables for this queries and a DDL script to insert data into these tables, because problems with performance can occur when query returns a lot of records.
Try to turn off all firewalls and other programs that check TCP/IP traffic. They can cause slow query execution.
If this method doesn't help to resolve your issue then try to find queries that are executed slowly and execute them in the SQL Plus utility. If the queries will be executed slowly in the SQL Plus utility then this is a performance problem in the Oracle client and you should ask the Oracle company for help. If queries are executed quickly in the SQL Plus utility then, please, send us the text of these queries. Also we need a DDL script to create tables for this queries and a DDL script to insert data into these tables, because problems with performance can occur when query returns a lot of records.