Subject | Re: [IBO] IBO Stored procedure under high load |
---|---|
Author | dirknaudts |
Post date | 2002-09-18T11:25:29Z |
Helen,
then again question remains why should the condition fail whereas it
succeeds on a 1000 other occasions. I mean the SP isn't runtime
created, so if the params are there the first x times, why shouldn't
they be an other time ? and it' s also always the same process
that "feeds" the params .
I am using FB 1.0.
Thanks,
Dirk Naudts.
>be
> Is this the actual logic of your handler? If so, then you seem to
> calling execproc in both success and fail conditions.Well, yes, and I guess i could put an extra test arround it , but
>
then again question remains why should the condition fail whereas it
succeeds on a 1000 other occasions. I mean the SP isn't runtime
created, so if the params are there the first x times, why shouldn't
they be an other time ? and it' s also always the same process
that "feeds" the params .
> >Is the prepare ok , or should I call unprepare before that ? Whyonly
> >failing every x times or so ?So question remains...
>
> What version of client and server are you using? If it isn'tFirebird 1,
> then you might be encountering some manifestation of the famousXSQLDA
> bug. For more info, see the article on the IBO news page - itapplies to
> all versions of InterBase and some of the FirebirdThanks for the link, I'll read it now,
> betas. http://www.ibobjects.com/iboNews.html
I am using FB 1.0.
Thanks,
Dirk Naudts.