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.

temporary tables

2 posts in Visual Basic Last posting was on 2005-01-14 08:23:23.0Z
Tom Snider Posted on 2005-01-13 21:57:04.0Z
Reply-To: "Tom Snider" <thomasgsnider@sbcglobal.net>
From: "Tom Snider" <thomasgsnider@sbcglobal.net>
Newsgroups: advantage.visual_basic
Subject: temporary tables
Date: Thu, 13 Jan 2005 15:57:04 -0600
Lines: 6
Organization: Tom Snider Software
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 69.153.60.199
Message-ID: <41e6eceb@solutions.advantagedatabase.com>
X-Trace: 13 Jan 2005 14:49:31 -0700, 69.153.60.199
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!69.153.60.199
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:925
Article PK: 1137719

I have noticed that the #Temporary tables I create are extrordinarily slow.
Is there any reason for this?

Tom Snider


Joachim Duerr (ADS Support) Posted on 2005-01-14 08:23:23.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: temporary tables
Newsgroups: Advantage.Visual_Basic
References: <41e6eceb@solutions.advantagedatabase.com>
Organization: Extended Systems GmbH
User-Agent: XanaNews/1.16.5.1
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 195.2.185.25
Message-ID: <41e7817b@solutions.advantagedatabase.com>
Date: 14 Jan 2005 01:23:23 -0700
X-Trace: 14 Jan 2005 01:23:23 -0700, 195.2.185.25
Lines: 13
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.2.185.25
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:927
Article PK: 1137720


Tom Snider wrote in <41e6eceb@solutions.advantagedatabase.com> :

> I have noticed that the #Temporary tables I create are extrordinarily
> slow. Is there any reason for this?

they are not slower than other tables. If you want to speed it up,
create indexes on that temp table.

--
Joachim Duerr
EMEA Lead ADS Support, Extended Systems GmbH, Germany
advantage[AT]extendsys.de
European Advantage Conference 2005: http://ads.extendsys.de/eac