Wednesday, June 30, 2004

From the Interbase trenches

Well, it seems that

select ... from my_proc(my_params, ...)
join my_table on ...

can be much slower than putting the code into a separate stored procedure and simply selecting * from it. Optimizer confused?
Oh well, I have to investigate some more, but some of my selects now run 6x faster... which is a good thing (TM) ;-)

Also, requesting plan on some complex queries (with a large plan) seems to crash ibserver. Doh... plan buffers limited in size to a hardcoded value? Found some hints on the newsgroups, turning off plan request on the client solves it, still it's hard to believe.

Saturday, June 26, 2004


Long time no post... I had an accident on in-line skates, my right arm was dislocated from my shoulder. It hurts but it's getting better slowly, at least I can type with both hands, finally.