Stan's slow problem EXPLAIN

[Stan Busk]

I get some like:

FOR SQL QUERY TIME = 69 :
	 DO SELECT : TIME = 69 : ROWS = 1
		 DO SIMPLE SELECT : TIME = 69 : ROWS = 1
			 DO Single Table Without GROUP BY : TIME = 69 : ROWS = 1
				FOR Table [tblArticle]  DO resolve WHERE statement : TIME = 69 :  
ROWS = 3765
					FOR Field [Article_Newsgroups]  DO FindLike : TIME = 69 : ROWS =  
3765

and most as:

FOR SQL QUERY TIME = 12 :
	 DO SELECT : TIME = 12 : ROWS = 1
		 DO SIMPLE SELECT : TIME = 12 : ROWS = 1
			 DO Single Table Without GROUP BY : TIME = 12 : ROWS = 1
				FOR Table [tblArticle]  DO resolve WHERE statement : TIME = 12 :  
ROWS = 3254
					FOR Predicate [AND] TIME = 12 : ROWS = 3254
						 DO AND Indexed operands : TIME = 0 : ROWS = 29234
							FOR Field [Article_Status]  DO FindLike : TIME = 0 : ROWS = 29234
						 DO AND Non-Indexed operands : TIME = 12 : ROWS = 3254
							FOR Field [Article_Newsgroups]  DO FindLike : TIME = 12 : ROWS  
= 3254

Meanwhile I am looking for that Non-Indexed operand.

Are they normal timings? No boolean involved here however queries are  
extremely slow.

Stan


> On 6/1/06 9:52 PM, "Stan Busk" <maxprog at mac.com> wrote:
>
>> Hi,
>>
>> With my other problematic app I get huge timings in 'Predicate' line
>> (compared to previous app):
>>
>> FOR SQL QUERY TIME = 2 :
>> DO SELECT : TIME = 2 : ROWS = 1
>> DO SIMPLE SELECT : TIME = 2 : ROWS = 1
>> DO Single Table Without GROUP BY : TIME = 2 : ROWS = 1
>> FOR Table [tblArticle]  DO resolve WHERE statement : TIME = 2 :
>> ROWS = 0
>> FOR Predicate [AND] TIME = 4290251425 :
>> TIME = 4290251425 :
>> FOR Field [Article_Status]  DO FindLike : TIME = 2 : ROWS = 0
>>
>> and so on...
>>
>> Always very big amounts for TIME. Does it correspond to ticks?
>
> I think this is a garbage value. Probably somewhere bug
>
>     0 - somevalue = negative = big integer
>
>
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta