Subject Re: [firebird-support] Re: InterbaseExpress
Author Martijn Tonies
> Yes I agree in keeping them short....
> But we have a procedure, that will select around 280.000 records (some
> varchar, some integer, some numeric etc).
> The program will iterate through them, and insert 1 new record for
> each of them.
> WITHOUT unidirectional I get a OUT OF MEMORY.
> WITH unidirectional I do not get this.
> At this point, I have to come up with a solution that will work NOW.
> I have to rewrite to code at some time, to make it better.
> So thats the reason......

Why not create a Stored Procedure for this :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!