Every single sql operation, from VACUMM to CREATE INDEX etc ... is
internally subdivided into tens or thousands of microinstructions for
the sqlite virtual machine.
Current version of the plugin yield time to RealBasic every 100
operations but ONLY during the SQLSelect method.
This is due to the possible performance penalty that yielding time to
RB for every single operation could involve.
If you think you really need a possible slower but more UI friendly
plugin I suggest you to file a feature request.
Regards,
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
On Jun 25, 2006, at 9:20 PM, Norman Palardy wrote:
On Jun 25, 2006, at 8:25 PM, Norman Palardy wrote:
I wasn't sure if REAL had taken advantage of that
I know the old SQLite plugins did not
Yes, it
Some early version must not have because long queries could
completely block every thing as though they were totally synchronous.
Later version of the SQLite plugin do seem to be better.
I know the REALSQLatabase does use it.
But is it possible to use it in ALL cases ?
Will Vacuum work this way ?
Analyze ? (is it implemented in the latest versions as it wasn't
for some and I filed a bug report)
Will DDL like create index on a very large table yield ?
I have some tables that are up to 1 Gb in size and some of the will
cause a program to be totally unresponsive when issued.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
