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

Back

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.