Its a 100BT network. Transferring 200megs around is not a problem at all.
In fact all the CSV files orignally come from a share on the network that
allows access to the FTP root. I can link those and process those extremely
fast.

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: Alan McDonald [mailto:alan@...]
Sent: Friday, March 12, 2004 7:02 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] RE: At my wits end

> Almost every day of the week files will be coming in that need to
> processed.
> They are all CSV formatted. They can contain anywhere from 100-1000000
> records. I would have to say that about 750,000 records per week is the
> average. The size of each record is averaged about 200 bytes (see the end
> of the post). It is being moved into a single table with 2 or 3
> indexes on
> it. ( All of the tests being performed were with 10 varchar(30)
> fields with
> no indexes, triggers, generators, or constraints)
>

Ed, you are trying to move 200Mb down the wire - what bandwidth are you
using on the test case and what bandwidth do you have at the real site?
Alan





Yahoo! Groups Links