Page 1 of 1

comments and slow query

Posted: Mon 02 May 2011 19:04
by adoniram
I'm perform a query on a sql server table with more than 269,993 records.

In this query I use LIKE statements and it take only "00:00:00.086" (less than 1 second) to run.

If I add some comment before this, the time jumps to "00:00:08.639" (almost 10 seconds).

I use fetchAll = false. If it's true then works fine.

My current version of Unidac is 3.60.0.15.


Can You help me?

Posted: Wed 04 May 2011 12:18
by AlexP
Hello,

I could not reproduce the problem.
Please send a complete small sample to alexp*devart*com to demonstrate it including a script to create a table.