Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Querry plan and real time result

5 posts in Xbase++ Last posting was on 2009-01-06 16:30:44.0Z
Toma? Grom Posted on 2008-12-24 07:46:47.0Z
From: "Toma? Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
Subject: Querry plan and real time result
Date: Wed, 24 Dec 2008 08:46:47 +0100
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 89.212.45.164
Message-ID: <4951e7cf@solutions.advantagedatabase.com>
X-Trace: 24 Dec 2008 00:42:07 -0700, 89.212.45.164
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.212.45.164
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1019
Article PK: 1140861

Hello !

I am using ADS with .CDX format indexes, so index structure is compund ('+'
instead of ' , ')

SQL engine of course does its work righ whether I write the SQL sentence
classical way, that is with comparing every single column name with paralel
column name in other table:

FROM mpdokpos AS P
INNER JOIN MPDOKGLA AS G
ON P.POSLLETO = G.POSLLETO AND P.FIRMA = G.FIRMA

or suitable to index structure, like:

FROM mpdokpos AS P
INNER JOIN MPDOKGLA AS G
ON P.POSLLETO + P.FIRMA = G.POSLLETO + G.FIRMA

Funny thing is, that in first case querry plan shows unoptimized
functioning, in second not.

But

The time result for final result is better in first unoptimized qerry.

How can it be ?

Best regards and merry Christmas

Toma?


Toma? Grom Posted on 2008-12-26 08:37:29.0Z
From: "Toma? Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
References: <4951e7cf@solutions.advantagedatabase.com> <6c56a9224766b8cb33c0bb8f60e4@devzone.advantagedatabase.com>
Subject: Re: Querry plan and real time result
Date: Fri, 26 Dec 2008 09:37:29 +0100
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 89.212.45.164
Message-ID: <495496b0@solutions.advantagedatabase.com>
X-Trace: 26 Dec 2008 01:32:48 -0700, 89.212.45.164
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.212.45.164
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1021
Article PK: 1140862

Rodd, thank you for your answer

At the same time I wish you all the best in the new year and plenty of
bussiness and personal success.

Best regards

Toma?

"Rodd Graham" <rgraham@grahamautomation.com> je napisal v sporo?ilo
news:6c56a9224766b8cb33c0bb8f60e4@devzone.advantagedatabase.com ...

> Hello Toma? Grom,
>
>> The time result for final result is better in first unoptimized qerry.
>>
>> How can it be ?
>
> Optimized is not the same as optimal.
> Just because Streamline SQL can utilize indexes to optimize the data
> access, it does not mean that the index usage is always the optimal access
> strategy for the specific dataset. Regardless, with SQL you should not
> care about the data access strategy of the server unless you have
> unacceptable performance.
>
> Given the choice, I would use the first statement anyway since it does not
> rely on the concatenation operator to create an intermediate value.
> However, Streamline SQL does take a bit of practice to understand how and
> when it uses DBFs and their index expressions.
>
> Regards,
>
> Rodd Graham, Consultant
> Graham Automation Systems, LLC
>
>


Toma? Grom Posted on 2009-01-05 13:47:55.0Z
From: "Toma? Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
References: <4951e7cf@solutions.advantagedatabase.com> <6c56a9224766b8cb33c0bb8f60e4@devzone.advantagedatabase.com>
Subject: Re: Querry plan and real time result
Date: Mon, 5 Jan 2009 14:47:55 +0100
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 89.212.45.164
Message-ID: <49620feb@solutions.advantagedatabase.com>
X-Trace: 5 Jan 2009 06:49:31 -0700, 89.212.45.164
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.212.45.164
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1022
Article PK: 1140863

Rodd, I would need one more help.

Namely before Christmas I tried that new SQL code at my customer, and it
worked without any problem.

Now it is not .

Customer has SBS2003 and ADS for 10 usres. Otherwise everything is the same,
like at my place, where I am running ADS for 2 users on a notebook.

One of SQL exectutes takes at my customer now endless time, instead of
approx 10 seconds.

I copied the entire database to my computer, where my centrino 1.7 makes it
in 8 seconds without any problem.

That is somehow closed box for me and can not find the way, why it happens.
Everything should be the same.

Could be the reason in a minor cahange in ADS 8.1, that would be so crucial.
I have version 8.10.0.26 installed, and my customer has version 8.10.0.2.

Any idea will be deeply appreciated !

Best regards

Toma?


Toma? Grom Posted on 2009-01-06 08:08:54.0Z
From: "Toma? Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
References: <49620feb@solutions.advantagedatabase.com> <6c56a922478fe8cb3d4ecfa26990@devzone.advantagedatabase.com>
Subject: Re: Querry plan and real time result
Date: Tue, 6 Jan 2009 09:08:54 +0100
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 84.255.247.224
Message-ID: <496311f9@solutions.advantagedatabase.com>
X-Trace: 6 Jan 2009 01:10:33 -0700, 84.255.247.224
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!84.255.247.224
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1024
Article PK: 1140864

Thanks, Rodd, you are right.

the only strange thing, that bothers me, is the fact, that before Christmass
it worked well and very quickly.
Also I have another SQL queries in paralel segment inside the same pogram,
that are working without any problem.

I will try to instal the same version of ADS and try again, as you had
suggested.

One more thing worries me.
When program goest to an 'endless' loop because SQL exectuin does not want
to end, I terminate the client.
But in that case below lines are not executed and SQL process does not end
and burden the server processor.

oThread:oSqlCursor:Destroy()
oThread:oSqlCursor := NIL
oThread:oSqlConn:Destroy()
oThread:oSqlConn := NIL

Is there any way to terminate that load any different way, than stopping the
ADS service manually ?

Best regards

Toma?


Toma? Grom Posted on 2009-01-06 16:30:44.0Z
From: "Toma? Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
References: <49620feb@solutions.advantagedatabase.com> <6c56a922478fe8cb3d4ecfa26990@devzone.advantagedatabase.com>
Subject: Re: Querry plan and real time result
Date: Tue, 6 Jan 2009 17:30:44 +0100
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 84.255.247.224
Message-ID: <49638790@solutions.advantagedatabase.com>
X-Trace: 6 Jan 2009 09:32:16 -0700, 84.255.247.224
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!84.255.247.224
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1025
Article PK: 1140865

Rodd,

with latest version of ADS 8.1 it went well !?

Thanks again and best regards

Toma?