On 8/17/2004 at 4:34 PM Lester Caine wrote:

> I'd be interested to se it run on PHP5, some work has been done on
> Interbase/Firebird module.
>
> But sticking to your problem. Can you kill sections of the code and
> see which area causes a problem. Kill the insert, and just let it
> update existing records, then run it again just adding missing
> records. Other option is to filter the raw data just to give all one
> type of record ( insert or update ).
>
> Also let Firebird add the Primary Key via a trigger.
>
> No answers, just a few ideas to pin things down. I run quite large
> files ( 2.5Mb ) through ibWebAdmin without a problem, but that is
> running PHP5.
>

Well, I'm back, and I'm afraid I have to stand up and sing the "I'm a little moron" song.....

It seems I had left a couple of diagnostic outputs deep down inside the processing of the records, below the level of the code I posted here (it was inside one of the functions). I found them, removed them, and it runs now. It is slow, but I should expect that. I'll see what I can do to improve that, and if all else fails I'll just write a little C++ program to read the data and do the import using IBPP.

Thanks for your help, Lester, and sorry to have bothered the list with this....

Dan.