>>So, on one hand your writes to the DB are slow, on the other hand your

reads are
fast. How many tiggers, indexes etc. do you have on that table? Maybe that
is
the whole culprit?>>

In the future I will have several indexes and triggers. However, for
testing purposes I only
have a table with 10 varchar(30) fields and no indexes, triggers,
constraints, etc.




Edwin Epstein

> Continuity Partners Inc.
> 2753 S. Highland Dr.
> Suite 1010
> Las Vegas, Nevada 89109
> (702) 851-7850 Ext. 247
> eepstein@...
>

CONFIDENTIALITY NOTICE: The information contained in this message may be
privileged and confidential and protected from disclosure.
If the reader of this message is not the intended recipient, or an employee
or agent responsible for delivering this message
to the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is
strictly prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer.




-----Original Message-----
From: Rafael Szuminski [mailto:raf@...]
Sent: Sunday, March 14, 2004 10:08 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] RE: At my wits end



<snip>
On frequent

> occasion (4-5 times a week) large sets of data will be exported based upon
> selection criteria. This is not a problem at all. I have used what has
> been termed a "firehose" connection. Its very fast. I have offloaded 2
> million records at around 5000 records per second to disk from a client.

So, on one hand your writes to the DB are slow, on the other hand your reads
are
fast. How many tiggers, indexes etc. do you have on that table? Maybe that
is
the whole culprit?

Btw, I noticed that you are working Continuity Partners Inc. in Vegas. I
hope
it's not the same tele-scam company that I have heard about....

Raf





Yahoo! Groups Links