Hello!
I did migrate two projects from PostgreSQL (one is ~22 Gb database with very
complex reports) and now migrate oracle project (>100 Gb billing database
with distributed data collectors) for best performance on multi-core servers
and SATA disks. SQLite database may be replicated or copied
OK, I've played with this a bit. Adding new columns to the datatable
through a custom function is really slow because it enumerates every cell in
the column. I don't need that -- I just need a blank column -- full of
nulls -- but with a column name.
I can add the columns to the datatable
Ah, ha! I had actually originally planned on doing that but when I read the
primary key could only be an integer I assumed it was a 32 bit integer so I
would need a separate column for the date. But you're right of course and I
see now that as of version 3, I can use 64 bit integers as the primary
>> I am running the rtree module against an SQLite build which has
>> lots of functionality SQLITE_OMIT_...ed.
>
>Can you be more specific? Exactly which SQLITE_OMIT symbols
>are defined?
Sure. Here is the list:
SQLITE_OMIT_ALTERTABLE
SQLITE_OMIT_ANALYZE
SQLITE_OMIT_ATTACH
On Jul 19, 2008, at 1:50 AM, Ralf Junker wrote:
> I am running the rtree module against an SQLite build which has
> lots of functionality SQLITE_OMIT_...ed.
Can you be more specific? Exactly which SQLITE_OMIT symbols
are defined?
> Surprisingly, I receive strange errors like SQLITE_NOMEM for
5 matches
Mail list logo
