comments and slow query
Posted: 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?
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?