Stan's slow problem EXPLAIN

[Stan Busk]

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?

Stan


> On 6/1/06 6:56 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua>  
> wrote:
>
> Btw, this is how looks EXPLAIN for Stan's query
>
>
> FOR SQL QUERY TIME = 63 :
>      DO SELECT : TIME = 63 : ROWS = 1
>          DO SIMPLE SELECT : TIME = 63 : ROWS = 1
>              DO Single Table Without GROUP BY : TIME = 63 : ROWS = 1
>                 FOR Table [tblTransactions]  DO resolve WHERE  
> statement : TIME = 63 : ROWS = 0
>                     FOR Predicate [AND] TIME = 63 : ROWS = 0
>                          DO AND Indexed operands : TIME = 63 : ROWS  
> = 219
>                             FOR Field [Transaction_Date]  DO  
> FindRange [01/01/2000 00:00:00:000, 12/31/2006 00:00:00:000] : TIME  
> = 0 : ROWS = 38727
>                            FOR Field [Transaction_Refunded]  DO  
> FindValue(1) : TIME = 25 : ROWS = 219
>                             FOR Field [Transaction_ChargedBack]  DO  
> FindValue(0) : TIME = 38 : ROWS = 38684
>                         DO AND Non-Indexed operands : TIME = 0 :  
> ROWS = 0
>                             FOR Predicate [OR] TIME = 0 : ROWS = 0
>                                  DO OR Indexed operands : TIME =  
> 0 : ROWS = 21
>                                     FOR Field  
> [Transaction_Country]  DO FindLike : TIME = 0 : ROWS = 21
>                                     FOR Field  
> [Transaction_Country]  DO FindLike : TIME = 0 : ROWS = 0
>
>
> -- 
> 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