Okay, i've got PRAGMA synchronous = OFF and PRAGMA temp_store = memory but i'm still seeing the system locking up and waiting for write when writing to sd-cards (insert statement in the middle of a batched transaction of them) (for reference, the standard linux filesystem doesn't have this blocking issue on doing cp/dd etc). Does anyone have any insight as to how to go about rectifying this? I'm seeing it blocking on writing to the database on every single insert. seeing as sd-cards are slow as hell, it's having a definate impact across the system (drawing, processing, etc even tho it's threaded off into a low priority thread).
Thanks in advance, Bill -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113 Tel + 61 7 3219 9906 (x137) Fax + 61 7 3219 9938 mobile: 0423 532 733 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
