Re: [opendbx] slow insert with sqlite

[Mariano M. P. <mar...@gm...>]

On Tue, Jul 5, 2011 at 11:11 PM, Alain Rastoul <al...@fr...> wrote:

> Hi Norbert,
> Yes they are problems with multi threading and sqlite, my question was
> about
> the opendbx implementation and/or the opendbx interface in Pharo. In Pharo
> there is only one vm thread,


yes


> but I thought that may be opendbx or the
> opendbx interface was doing the call in another thread  and the vm thread
> was waiting for completion?
>

yes, exactly. But only if the backend and database client library support
that.


> Are they documents about the opendbx architecture and or the opendbx
> interface in Pharo (couldn't find on the web site).
>

Check the links I've sent you and the emails I have forwarded to squeakdbx
mailing list.
After you have read Hernik mails I can point you to the code if you want ;)


> Thank you for your answer
>
> Regards
> Alain
>
> "Norbert Sendetzky" <no...@li...> a
> écrit dans le message de news:4E1...@li......
> > Hi Alain
> >
> >> I've done a small program in Pharo 1.3 with glorp+opendbx that insert
> >> 1000
> >> rows in a customer table in a sqlite db.
> >> The 1000 insert takes 140 sec (very slow), but the Pharo profiler says
> >> that
> >> it spend 95% of the time waiting for input.
> >
> > I can't speak for the Pharo implementation but SQLite is known for being
> > problematic when at least two threads trying to write to the same
> > database file.
> >
> >
> > Norbert
> >
> >
> ------------------------------------------------------------------------------
> > All of the data generated in your IT infrastructure is seriously
> valuable.
> > Why? It contains a definitive record of application performance, security
> > threats, fraudulent activity, and more. Splunk takes this data and makes
> > sense of it. IT sense. And common sense.
> > http://p.sf.net/sfu/splunk-d2d-c2
>
>
>
>
> ------------------------------------------------------------------------------
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security
> threats, fraudulent activity, and more. Splunk takes this data and makes
> sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-d2d-c2
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>



-- 
Mariano
http://marianopeck.wordpress.com