I think I see more what you are talking about.

There shouldn't be any prepare if PreparedEdits is set to false.

Will you please make me a simple sample application showing your case where
it is generating a Prepare?

Perhaps you have something in your UpdateSQL property? (This takes
precedence over the PreparedEdits property.)

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, February 24, 2003 11:40 AM
Subject: Re: [IBO] PreparedEdits does not work as expected?


> It has to be prepared once at least. The difference is that once prepared
it
> will remain so in order that subsequent executions(posts) will not have
the
> overhead of preparing the statement to handle the update.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> -- We may not have it all together --
> -- But together we have it all --
>
>
> ----- Original Message -----
> From: <ibo@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Friday, February 21, 2003 5:15 AM
> Subject: Re: [IBO] PreparedEdits does not work as expected?
>
>
> > Svein,
> >
> > Great! Now we come to the point: why "But this ad-hoc DSQL still has
> > to be prepared before being executed." as you said? It really matters
> > because each prepare generate 40KB traffic from server to client,
> > this is expensive for remote client. If only it doesn't prepare and
> > just execute. I think that is technically possible.
> >
> > I am always finding ways to optimize for remote clients.
> >
> > Rgds,
> > Michael