Query extremely slow with Oracle XE

defferrari · Post by **defferrari** » Wed 23 Mar 2011 17:57

I have an application based on Unidac. Now I added a new sql query using a TUniQuery. When I run the application using the final database (Oracle 10g XE), that query is extremely slow, taking about 30 min, but If I run then application in my test database (Oracle 11g) it runs in few seconds. Additionally, if I run the query via SQL Develloper it takes 7-8 seconds in both databases.
I´m using:
- Delphi 7
- Unidac version 3.60.0.15
- Windows 7 and Windows XP
- Oracle 11g e Oracle 10g XE

AlexP · Post by **AlexP** » Thu 24 Mar 2011 13:40

Hello,

Please specify the text of your query and a script to create the tables used in the query.

defferrari · Post by **defferrari** » Mon 04 Apr 2011 13:25

Thank you for trying to help me but I gave up of trying to solve this problem. It is very specific and the fact that it happens in a BD and does not happen in other BD, makes this problem very dificult to be reproduced. But I get a workaround, I rewrote the query, putting some code in a BD function and now the query runs quite fast