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 ?
Hi Julian,
We did not see any performance problems as such.Can you please share the queries that you are running ?
Thanks & Regards,
Rajesh
Have you updated your stats recently?
no, but as mentioned we moved from 10.2 to 11.1 ..
"no" would be the wrong answer...