> A lot of the time using the vanilla API keeps you from coding in the
> style most suited for a modern lang, which may only help introduce
> bugs which the dev isn't used to worrying about. I don't think it's
> right to recommend using it when there are wrappers tailored to keep
> the dev
Monday, June 19, 2006, 07:37:22, Manzoor Ilahi Tamimy wrote:
> The Database Size is more than 500 MB.
> It contain one table and about 10 million Records.
I had problems with even more records (roughly 25 million, > 1GB of
data) and I've stopped efforts to do it in pure sqlite in the end, also
Monday, May 22, 2006, 15:17:21, Jay Sprenkle wrote:
> On 5/22/06, Dennis Jenkins <[EMAIL PROTECTED]> wrote:
>> Brannon King wrote:
>> > The benefits I'm trying to get out of sqlite are the data queries. I
>> > collect a large, sparse 2D array from hardware. The hardware device is
>> > giving me a
Sunday, May 21, 2006, 02:10:31, Brannon King wrote:
> The documentation says to put the database name on the front of the
> index name, not the table name when using the create index command. I
> thought it was weird myself.
Thank you, it has done the trick! I missed this in CREATE's
I'm receiving sql errors like the following
"no such table: main.phs_matrices_1"
when trying to create an index using the syntax:
"CREATE INDEX IF NOT EXISTS phsm_1_idx ON phs_matrices_1 (a, b, c)"
from my C++ program.
The error statement is true - phs_matrices_1 doesn't belong to main,
but
> It is not a smart technique to assume that you can access underlying
> data structures and expect them to remain identically placed between
> releases.
What do you think, was my reason to ask, whether these structures are public
and stable or not ... ;-)
Micha
--
Thursday, May 18, 2006, 17:36:53, Jay Sprenkle wrote:
> Since you pass that in to begin with, why do you need the database
> to provide information you already have?
Thats by design (tm), but it might be not the best one. For performance reasons
I have splitted my project in a way, requiring 2
@list
Maybe I'm too C++ biased - but what is the state of the sqlite3 and
similar - e.g. 'Db' - structures in sqlites C-Interface ? Is this
considered 'public' and also stable or indicates the missing
documentation (at least I've found nothing apart from the sources) not to
use them in user code
Hi list,
I'm running in a performance bottleneck in the following situation:
Database ~1.2 GB, sqlite 3.3.5, WinXP
~200 tables [phs_matrices_1 - phs_matrices_200] building the bulk of the
database. No AUTOVACUUM has been set.
Trying to drop these tables, the whole action requires ~2:45 min. The
Thursday, May 11, 2006, 09:36:17, Preston & Chrystie wrote:
> if your first statement after creating the database is:
> PRAGMA encoding = "UTF-16";
> then the error you get is slightly different:
sqlite>> ALTER TABLE test1 ADD straße VARCHAR(255);
> SQL error: malformed database schema - near
Wednesday, May 3, 2006, 06:42:34, E Tse wrote:
> I am planing to use sqlite for a project involving huge data. The planned
> sqlite file (which will contain a single table) will grow to more than 4g in
> size. Has anyone try that before and what problems have you encountered?
Be prepared, that
@list
Following the documentation, the two functions have been declared
'experimental'. Does someone know, how reliable these calls are actually
? There are specific serious open issues, rough estimates when to fix
them, etc. ?
Micha
> Hi,
> I would like to compile the SQLite 3 sources directly into my app.
> Since I'm using Visual C++ 6 how can I configure the sources to allow
> me to compile them?
> Can I use MSYS and run /configure and then just copy the
> 'configured' sources to my Visual C++ app and compile them there?
Thursday, March 23, 2006, 03:44:11, Teg wrote:
> Hello Jay,
> Best way I've found to get great performance out of strings and
> vectors is to re-use the strings and vectors. String creation speed is
> completely dependent on allocation speed so, by re-using the strings,
> you only grow the ones
Eventually, I've got my lesson. Because it might be of some interest for
the beginner:
1)Use the associated sqlite3_bind_* variants for your data.
I did make a mistake in converting forth and back to strings beforehand.
2)It broke my program design a bit, but setting up large STL vector
based
Hallo list,
I'm relatively inexperienced when it comes to databases and SQL (but to
programming). I'm using sqlite's (recent version) C API called from a
C++ application.
I'm confronted with the following situation:
Ca. 2500-3000 objects (called 'entity') everyone with 3 properties (REAL
in
16 matches
Mail list logo
