In date 30-03-2001 13:30, Ruslan Zasukhin wrote:
>>>> Select a.Complete_Name, b.Titolo From Distinct [Artisti] a, [Media] c,
>>>> [Album] b,Alb_Med_Linker,Art_Alb_Linker Where a.RecID = 1698
>>>> (this will run in 13 ticks)
>>>>
>>>> Select a.Complete_Name, b.Titolo From Distinct [Media] c, [Artisti] a,
>>>> [Album] b,Alb_Med_Linker,Art_Alb_Linker Where a.RecID = 1698
>>>> (this will run in 1510 ticks!!!!)
>>>>
>>>> they're the very same query!
>>>> only difference is in postition of From BO's
>>>>
>>>> This drives me crazy
>>>> please give it a glance
>>>
>>> I can bet one of this switched table is very very big.
>>> So when you set it first it produce a lots of not needed results.
>>>
>>
>> the largest BO is Media and holds about 40000-50000 records
>>
>> So, to-date, only workaround is check the BO sizes
>> into the query builder and move smaller BOs first
>>
>>> Yes, this is one more thing to optimize.
>>> This is not SQL parser, this is SQL engine.
>>>
>>
>> but why in the world the engine don't work on found record set
>> based on query Where clause?
>>
>> IMHO it should resolve Where first and links after
>>
>> Sorry to insist,
>> any timetable to fix this?
>> it makes my app look very clunky while could be smooth as silk.
>
> Erne, it hard to explain all aspects...
>
> I am not sure this is simple fix, it require adding of new analytic code.
> Yes WHERE is resolved first. true,
> but then start play links and here is used order in FROM statement.
>
Hi,
yes parser or engine should analyze query in deep to find best route
but, Ruslan, this is what we expect from Valentina
Be fast, FAST, FASTER!
and what is worth to gain a tick or two in hidden kernel routines
when we lose THOUSANDS in a simple query?
again IMHO this should be HIGH PRIORITY!
well stop complaining
I've managed some workaround myself
dealing with query involving only 1 BO in WHERE clause
things get done by putting it first in the FROM statement
can't tell enough if more than a BO involved in WHERE clause
but going to tackle this
Cool Runnings,
Erne.
| e r | Ernesto Giannotta
| n e | Musical Box - a media store
©2001 erne |
