comments and slow query

adoniram · Post by **adoniram** » Mon 02 May 2011 19:04

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?

AlexP · Post by **AlexP** » Wed 04 May 2011 12:18

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.