Re: wc_db performance

On Tue, Mar 15, 2011 at 10:34, Philip Martin <philip.martin_at_wandisco.com> wrote:
>...
> So with the temporary table approach the callback really has to use a
> separate database connection to read/write the database from within the
> callback.
>
> However I think that is also the case if we were to avoid the table and
> simply lock the main database; if just one connection was reused it
> might be attempt to reuse an SQLite statement.

And note that we work really hard to use a single SDB connection. We
re-use that as much as we can. I don't even know how we'd start to
bring in more connections. Maybe under the covers, wc_db could open
specialized connections.

But, really?

Why can't we simply put restrictions on those callbacks? I'm unclear
on this part.

Cheers,
-g
Received on 2011-03-15 20:44:52 CET