There is only one IB server running on the network. The data gets imported
into it. For the major files each week its gets processed into 1 of 11
different tables on that server. The front-end also directly manages other
tables on the same server. No problem with them since all of them have less
than 500 rows to work with and inserts on them are very rare and only 1-2
rows are inserted at any one time. Result files that are exported from the
1 to 11 tables are exported using an ADO recordset object and then creating
the file with an ADO stream object. No speed problem here since i used a
"firehose" cursor which was recommended for speed.
adForwardOnly+adUserServer+adLockReadOnly and a cachesize set to 1.

So far there have been 5 different methods of insertion:

1) scripting file created by the front-end and sent to the IB Server to be
executed via a DOS shell using the ISQL program. Uses simple Insert
statements to put it into a tempory table that a store procedure operates on
later.
2) scripting file created by the front-end and sent to the IB server to be
executed via a DOS shell using the ISQL program. Uses a stored procedure
directly from the script.
3) ADO execution from the front-end. Insert statements and then later on
after all rows have been inserted a stored procedure to operate on all the
added rows.
4) ADO execution from the front-end. Stored procedures executed via SQL.
5) ADO command execution of a stored procedure using named parameters.


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: Monday, February 09, 2004 5:17 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] External File Construction

> All data is in either CSV format or in some limited cases DBF v4-5 during
> import and export.
>
> There is only a single IB Server. Replication of data from a
> central server

I'm afraid you've really lost me now - only one server? where does the data
get imported to?


Alan





Yahoo! Groups Links