> This pragma speeds up most processes 10-20 times (yes 10-20):
> pragma synchronous=OFF
>
> See the SQLITE documentation for an explanation.
> I've found no problems with this setting.
Aside from database integrity and consistency? :) I have that one set
to OFF as my case mandates data processing
On Tuesday, September 3, 2013 8:22:42 AM UTC-4, Alister wrote:
> On Mon, 02 Sep 2013 22:13:27 +, Joseph L. Casale wrote:
>
>
>
> > I have been battling an issue hopefully someone here has insight with.
>
> >
>
> > I have a database with a few tables I perform a query against with some
>
On Mon, 02 Sep 2013 22:13:27 +, Joseph L. Casale wrote:
> I have been battling an issue hopefully someone here has insight with.
>
> I have a database with a few tables I perform a query against with some
> joins against columns collated with NOCASE that leverage = comparisons.
>
> Running t
I have been battling an issue hopefully someone here has insight with.
I have a database with a few tables I perform a query against with some
joins against columns collated with NOCASE that leverage = comparisons.
Running the query on the database opened in sqlitestudio returns the
results in un
