Subject Re: [ib-support] %100 CPU usage with interbase, is it usual?
> >I have only one table, 3 field, and 1.000.000 record txt file, I
> >read data from txt file with a while loop using IBODatabase, IBOQuery,
> >IB_Script, first delete all the record, and then read the data one by one.
> >insert into GDB and then post. thats all. PIII 650 my computer is, 192 RAM,
> >WinNT
> Kursat:
> You must provide more information!

We probably need to take this to the IBO list, but in
general the problems of getting newcomers working the
correct way is always going to happen.

Kursat's problem has been being discussed for some time in
various threads, most of the information on what he is
trying to do has already been posted, so his NOT repeating
it is probably good netiquet. What he is doing is
implementing bits and pieces he has been told to so far. He
now has a working system, but it is slow. So the question is
- is it naturally slow because of the problem and hardware?
or can it be improved.

From the IBO perspective, a nice sample for bulk import of
raw data could be useful. I think most of what is required
already exists in the samples. Yes - processing the raw data
could help, but MY first problem would be HOW, which is
what, as a newcommer, he has been asking. Then working with
the samples be has got to the point where he can ( from a
standing start of not even knowing Delphi ) do what HE
want's to do.

So back to the problem.

I know ABOUT perl (after 30 years programming), but I don't
know where to get it or how to use it !! So how does Kursat

I have not succeeded in getting External tables doing this
sort of processing, so reading a record and inserting it
seems sensible to me, at which point Helen's other
suggestions come into play. We had not got the datapump
working because the data is variable, but we are probably
looking to the fast insert of three values read from a file
and inserted via an IB_DSQL or even a stored procedure.

Pointers please because I could not find them - I had a late
night none computer related <g>

Helen - is there any decent IBO stuff on importing?

Lester Caine
L.S.Caine Electronic Services