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.

SQL Performance

2 posts in FoxPro Last posting was on 2007-01-08 17:46:47.0Z
Leonid Kizelshteyn Posted on 2007-01-05 19:45:30.0Z
From: "Leonid Kizelshteyn" <leokiz@comcast.net>
Newsgroups: Advantage.FoxPro
Subject: SQL Performance
Date: Fri, 5 Jan 2007 14:45:30 -0500
Lines: 92
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_00CE_01C730D8.25616EC0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 24.60.25.241
Message-ID: <459ea9e0@solutions.advantagedatabase.com>
X-Trace: 5 Jan 2007 12:41:20 -0700, 24.60.25.241
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!24.60.25.241
Xref: solutions.advantagedatabase.com Advantage.FoxPro:215
Article PK: 1109569

Hi, there!
I'm using ADS quit a while but discovered the problem only recently.
I'm doing a lot of data conversions and some of them into ADS DB. Usually I'm working with empty DB, so the problem for me wasn't obvious. In my code before starting put converted records into file of the DB, the command {delete from <Table>} issued just to make sure that the table will contain only correct data. Recently I've uncovered some error in my code when the conversion was done and I have to do it again. For my amusement, it took hours(!!!!) to clean aprox 3000 records in a table.
Tried same thing in ARC. Same performance. Is this by design? Or I'm missing something in setup?
 
System info:
Processor - Sempron 1.8 Mhz, 704 MB RAM, 40Gb disk space free
Original program - VFP 8.0 SP1
ADS ODBC driver vers..8.10
 
Command issued  - delete from mwpat  where mwpat is a table in ADS DB
 
Execution took 1.5 hours (system was dedicated to this task, no multitasking)
 
Any ideas and explanations appreciated. Thanks in advance!
 
Leo


Mark Wilkins Posted on 2007-01-08 17:46:47.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.FoxPro
References: <459ea9e0@solutions.advantagedatabase.com>
Subject: Re: SQL Performance
Date: Mon, 8 Jan 2007 10:46:47 -0700
Lines: 140
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_048C_01C73312.4BBF13B0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 10.24.38.228
Message-ID: <45a28286@solutions.advantagedatabase.com>
X-Trace: 8 Jan 2007 10:42:30 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.FoxPro:216
Article PK: 1109570

Hi Leo,
 
Is it using local server with the file on a networked drive?  If that is the case, it might be somewhat slow ... but not 1.5 hours.  That doesn't make sense to me.  I just now ran a "delete from table" on a 40,000 record table with 4 indexes.  It took 10 seconds. 
 
While it does not answer the question of what is going on, another possibility is to used the system stored procedure "sp_ZapTable".  If you are wanting to simply clean the table, that would be the fastest way to do it.

Mark Wilkins
Advantage R&D
"Leonid Kizelshteyn" <leokiz@comcast.net> wrote in message news:459ea9e0@solutions.advantagedatabase.com...
Hi, there!
I'm using ADS quit a while but discovered the problem only recently.
I'm doing a lot of data conversions and some of them into ADS DB. Usually I'm working with empty DB, so the problem for me wasn't obvious. In my code before starting put converted records into file of the DB, the command {delete from <Table>} issued just to make sure that the table will contain only correct data. Recently I've uncovered some error in my code when the conversion was done and I have to do it again. For my amusement, it took hours(!!!!) to clean aprox 3000 records in a table.
Tried same thing in ARC. Same performance. Is this by design? Or I'm missing something in setup?
 
System info:
Processor - Sempron 1.8 Mhz, 704 MB RAM, 40Gb disk space free
Original program - VFP 8.0 SP1
ADS ODBC driver vers..8.10
 
Command issued  - delete from mwpat  where mwpat is a table in ADS DB
 
Execution took 1.5 hours (system was dedicated to this task, no multitasking)
 
Any ideas and explanations appreciated. Thanks in advance!
 
Leo