Subject RE: [IBO] Big Batch...
Author Christian Kaas
If done right the whole thing shouldn't run any longer than a few
seconds (i tried a little benchmark against my linux server PII 350
512MB RAM, UDMA/66 IDE drives) and it took only a few seconds for ten
thousands of records in a table with more than one attribute!
use tib_dsql with parameters and use the prepare methode once, and
execute the sql then in a loop.

something like:

>- snip------------------------------------------
with yourib_dsql do
while true do
newSymbol := gettickerSymbol; // assumed this is a function returning
a string with the next symbol
if newSymbol = '' then

Parambyname(':val').asstring := gettickerSymbol;


This will ROCK your instance and be THE FASTEST way!


Christian Kaas mailto:christian@...
Client/Server/Internet/Multitier development

> -----Ursprungliche Nachricht-----
> Von: Admin [mailto:dkeith@...]
> Gesendet: Freitag, 16. Marz 2001 02:58
> An:
> Betreff: [IBO] Big Batch...
> I am downloading the symbol lists for the 4 major american stock
> exchanges. This list grows in size every day, currently over 14,300
> symbols. I then parse out the symbol data and insert it into a single
> column(CHAR), unindexed table in IB6. The only way I yet know
> how to do
> this is with an INSERT INTO SYMBOLS (SYMBOL) VALUES (val); statement
> that inserts one row at a time, using an IB_Connection & TIBOQuery.
> I've tried various approaches such as dividing up the list
> into chunks,
> and then using several threads to insert the data. This would speed up
> the process a little, but I keep getting 'Error reading data from
> connection' or 'Error writing data to connection' or something like
> that.
> I would like to do this as quickly as possible. Any ideas?
> TIA.
> David Keith
> [Non-text portions of this message have been removed]
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-~>
> Make good on the promise you made at graduation to keep
> in touch. has over 14 million registered
> high school alumni--chances are you'll find your friends!
> --------------------------------------------------------------
> -------_->
> Your use of Yahoo! Groups is subject to