Subject Re: SELECT ONLY database query performance
Author Stan
Thanks for the information.

Is there anything else that we need to do
when implementing a multi-threaded client application
other than:

1. Create a separate DB connection for each thread
2. Synchronize the isc_attach_database calls

?

thanks,

stan

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:
>
> --- In firebird-support@yahoogroups.com, "Vlad Horsun" <hvlad@> wrote:
> >
> > > > I not quite sure that attach synchronization is required for
> > > _embedded_
> > > > but it can't hurt performance if your application make something
> else
> > > > except of connect\disconnect ;)
> > >
> > > Do you mean disconnect calls (eg TIBDatabase.Close) should also be
> > > serialised in the same way as attach calls?
> >
> > No, disconnect serialization is not required.
> > At least my MT tests worked fine without it ;)
>
> Thanks Vlad,
>
> You just mentioned performance being hurt in connect/disconnect, so I
> thought that must mean something about serialising disconnects.
> Anyway, I have fixed our app, thanks for your knowledge :)
>
> Adam
>