sql query slow

Posted by jmls on 26-Oct-2012 06:13

We've moved our database server from to 11.1 64 bit from 10,2B 32 bit. Our SQL queries how slowed down by  a factor of at least 50, perhaps even 100. However our 4GL queries are faster than ever.

A client/Server 4gl query on the "history" table reads almost 30,000 records per second (we have a -B of 4,000,000)

The same query in sql is reading less than 100 records per second

We have not modified the sql query in any way, except for deleting the odbc entry for 10.2B and recreating for 11.1. All reads are uncomiitted. The query is being run from an i7 desktop with 11.1 32-bit and 8gb ram.

I am investigating the queries myself now, but just wondered if anyone else has had performance issues with 11.1 SQL ?

All Replies

Posted by DVRajesh on 26-Oct-2012 07:04

Hi Julian,

We did not see any performance problems as such.Can you please share the queries that you are running ?

Thanks & Regards,

Rajesh

Posted by Rob Fitzpatrick on 26-Oct-2012 12:46

Have you updated your stats recently?

Posted by jmls on 28-Oct-2012 13:45

no, but as mentioned we moved from 10.2 to 11.1 ..

Posted by ChUIMonster on 06-Mar-2013 16:14

"no" would be the wrong answer...

This thread is closed