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.

Speeding up queries

3 posts in PB Infomaker Report Writer Last posting was on 1998-06-25 00:05:44.0Z
Christopher F Jackson Posted on 1998-06-13 20:22:23.0Z
Newsgroups: sybase.public.infomaker.general
Date: Sat, 13 Jun 1998 16:22:23 -0400
From: Christopher F Jackson <cfjackson@earthlink.net>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
MIME-Version: 1.0
Subject: Speeding up queries
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 9
Message-ID: <348_3582DF7E.EBAFD361@earthlink.net>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7068
Article PK: 243097

Does anyone have any ideas in speeding up queries other than fine tuning
SQL?
maybe there is a IM6.0 setting I am missing, seems slow crosstabs take a
long time to finish.

Also, Is there a way to print the profile, database or users name on a
report?

Thanks

Christopher F Jackson
Data Analyst
Port Authority of NY & NJ


Terry Dykstra [TeamPS] Posted on 1998-06-15 18:32:07.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Speeding up queries
Date: Mon, 15 Jun 1998 12:32:07 -0600
Lines: 28
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_ekVojJIm9GA.155@forums.powersoft.com>
References: <348_3582DF7E.EBAFD361@earthlink.net>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7062
Article PK: 243091

Run the crosstab query by itself, or against another report. If it goes
much faster, then the crosstab itself is doing something. If the speed is
roughly the same, you will have to tune the select statement.
Crosstabs will generally be slower, because there is lots of sorting,
regrouping etc that must be done to get the data in the correct format. The
more memory you have, the better.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Christopher F Jackson wrote in message <3582DF7E.EBAFD361@earthlink.net>...
>Does anyone have any ideas in speeding up queries other than fine tuning
>SQL?
>maybe there is a IM6.0 setting I am missing, seems slow crosstabs take a
>long time to finish.
>
>Also, Is there a way to print the profile, database or users name on a
>report?
>
>Thanks
>
>Christopher F Jackson
>Data Analyst
>Port Authority of NY & NJ
>
>


Christopher F Jackson Posted on 1998-06-25 00:05:44.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 24 Jun 1998 20:05:44 -0400
From: Christopher F Jackson <cfjackson@earthlink.net>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
MIME-Version: 1.0
Subject: Re: Speeding up queries
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 31
Message-ID: <348_35919458.94B4E8C4@earthlink.net>
References: <348_3582DF7E.EBAFD361@earthlink.net> <348_ekVojJIm9GA.155@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7034
Article PK: 243066

Terry,

I thought over what you said and I added more memory from 64megs to 192megs
I purchased 128 more. Crosstabs that took 45min to 1hr are now running 10 to
15min now its great no more hard drive thrashing. Thanks

Terry Dykstra [TeamPS] wrote:

> Run the crosstab query by itself, or against another report. If it goes
> much faster, then the crosstab itself is doing something. If the speed is
> roughly the same, you will have to tune the select statement.
> Crosstabs will generally be slower, because there is lots of sorting,
> regrouping etc that must be done to get the data in the correct format. The
> more memory you have, the better.
>
> --
> Terry Dykstra [TeamPS]
> Canadian Forest Oil Ltd.
> Christopher F Jackson wrote in message <3582DF7E.EBAFD361@earthlink.net>...
> >Does anyone have any ideas in speeding up queries other than fine tuning
> >SQL?
> >maybe there is a IM6.0 setting I am missing, seems slow crosstabs take a
> >long time to finish.
> >
> >Also, Is there a way to print the profile, database or users name on a
> >report?
> >
> >Thanks
> >
> >Christopher F Jackson
> >Data Analyst
> >Port Authority of NY & NJ
> >
> >