Subject Re: Windows server 2003
Author tymorrisy
--- In firebird-support@yahoogroups.com, JD FitzGerald <jd@h...> wrote:
> tymorrisy wrote:
> >
> > How many people are using windows server 2003 with firebird 1.5.x?
> >
> > Is anyone having trouble with it?
> >
>
> A client is running superserver on 2003. I've been having problems with
> the process hogging lots of processor time and the biggest of the dbs
> (~600mb) getting hella slow.
> Are you using a lot of stored procedures? Because they've been the
> biggest problem for me; they're getting real slow. The only solution I
> found was to move a lot of the work to the client application. Things
> are still a bit ropey though.
> My next plan is to move to classic and see if that helps...

I have been testing it this week for the first time on 2003. The app
I am testing does not use alot of sp's but it does us some plan
statements. These have caused it to crash the firebird engine for me.
I can take out the plan part of the sql statement and it runs fine,
but I am having to fight with the programmers on that product to get
it done.