Paul,

10 secs per field? (why do you write field for field?, is this a typo
and you meant record???)

I do think, you should really speed up, your writing :-)

Of course there's no rule, how fast data is written (hardware equipment,
record size, etc. all influence this), but you should be able to write
any record within the fraction of a second.

Or yo you have triggers on that table, that will call a lot of other
things that will slow down the write that dramatically????

Luc

Paul Little schrieb:

>
> Hi,
>
> I noticed a couple of threads in the past about the speed (or lack of
> it) with IBO. I have just completed the first stage of my app and tried
> it out.
>
> I was a bit dissapointed by the speed that my data was written to the
> database. By rough timing it was about 10 seconds per field. Is this
> normal or is there something I could do to speed things up a bit?
>
> I am using:
> IBO3.6
> Interbase 5.6
> Delphi 5 (proff)
>
> My c/s app lives on a single machine (i.e. no network) and writes to the
> db are done via sp's which are called within a loop and write one field
> per record on each activation.
>
> Any hints gratefully received.
>
> TIA
> Paul