Seems like the only thing that can help you is in
yahoo group's file section ;-)
> I am not yahoo group member
Become a member, its free. Get the files and then
unsubscribe.
HTH,
Jalil Vaidya
--- Jorge <[EMAIL PROTECTED]> wrote:
> No, no...
>
> there is not mentioned VBWrapper.zip
>
>
> 1)
Point certainly taken. I was trying to avoid getting into too much
detail without first confirming if this was some well known issue.
I'll put together a standalone test app which will demonstrate the poor
loading/insert performance. I'll get to the read performance after
that.
-Original
"Ismail Kizir" <[EMAIL PROTECTED]>
17/06/2004 06:48 PM
To: <[EMAIL PROTECTED]>
cc:
Subject:Re: [sqlite] RE: SQLite performance with mid-size databases
> I had the same problem as Richard's.
> Unfortunately, i have decided to use postgres and finally back
Raymond,
So far on this list I have only seen a reports of scalability problems
with sqlite when the real problems were specific queries being given to
sqlite that were constructed in a way that sqlite does not process well.
In every such case I can recall an alternative form of the query was
No, no...
there is not mentioned VBWrapper.zip
1) DLL for VB 6/5/4 like as ADO free!! by Javier Bermudez from Argentina.
http://free.hostdepartment.com/j/javierbermudez/archivos/sqlite/index.html
isn't active
Visual Basic 6 http://www.ag-software.com/SQLite/default.asp
it's OK, but it isn't
How much should I worry about this?
Assertion (pPager->ckptJSize ==
pPager->nRec*JOURNAL_PG_SZ(journal_format)+JOURNAL_HDR_SZ(journal_format))
failed in "pager.c", line 2128
This is in version 2.8.13. After resaving the file, the assertion no
longer fails.
--
James W. Walker,
Check out COM Wrappers / Visual Basic DLLs section in
the wiki:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
HTH,
Jalil Vaidya
--- Jorge <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Are there any site whehe can I found the mentioned
> VBWrapper.zip?
>
> I have tried in
I'm joining this late, but I just updated the wiki.
Appearently SQLRelay already has this worked out?
http://sqlrelay.sourceforge.net
-Original Message-
From: Nicolas Girard [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 2:44 PM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Is
Hihn, Jason wrote:
I'd like to know how hard it would be to make "integer primary key" be
64 bits wide. I have and application that will burn through 2^32 in
about 3 months in the main index table. I know I'll be well under the
size limitation of 2^41 though.
64-bit rowids are support in SQLite
I searched the archives, and only found info relating to the proposal
for v3.
I'd like to know how hard it would be to make "integer primary key" be
64 bits wide. I have and application that will burn through 2^32 in
about 3 months in the main index table. I know I'll be well under the
size
Ulrik Petersen wrote:
this is also just a stab in the dark, and I subscribe to the digest
version of the mailinglist, so I may not have the latest.
Perhaps you are doing something like
SELECT A.x, A.y
FROM A
WHERE A.rowid = xxx
OR A.rowid = yyy
OR A.rowid = zzz
OR A.rowid = ...
etc.etc.
Jacob Engstrand wrote:
>
> On 2004-06-17, at 16.39, [EMAIL PROTECTED] wrote:
>
>> If you have a large record size, then it also helps tremendously to put the
>> indexed columns first in the row (I had a table with large blob data that
>> was terribly slow to query until I moved the small,
On 2004-06-17, at 16.39, [EMAIL PROTECTED] wrote:
If you have a large record size, then it also helps tremendously to
put the
indexed columns first in the row (I had a table with large blob data
that
was terribly slow to query until I moved the small, non-blob columns
first).
[That was found
As you can see, there is old
release.
It is correct. For most cases it is sufficient
to replace sqlite.dll with given on
homepage.
And run the server on the remote
machine.
The SqliteBrowser is only for
testing!!!
BUT:
Current State is not on the homepage. I am
currently working on
Sorry for broken link. It is http://www.it77.de/sqlite/sqlite.htm
- Original Message -
From: "Alex K" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 17, 2004 4:20 PM
Subject: [sqlite] Is there a demand for Client / Server Modules ?
> I am about to register a project
I am about to register a project at SourceForge which
provides the Client/Server facility to SQLite. Using
SQLite over NFS is known as unsafe.
Some description is in Wiki/ClientServer and at www.it77.de/sqlite
The Windows version is currently working quite stable.
The Linux version has sometimes
See below:
--- Jacob Engstrand <[EMAIL PROTECTED]> wrote:
> To disable the
> I1A index,
> rewrite the WHERE clause like this:
>
> SELECT * FROM t1 WHERE a+0=5 AND b='xyzzy';
>
> To disable the I1B index you could write
>
> SELECT * FROM t1 WHERE a=5 AND b LIKE 'xyzzy';
>
Why
Well this does not sound good at all. I would think
that SQLite would at least do a better job at queries.
The issues with performance and scalability is of
great concern. I was planning on create some new apps
that use SQLite, but now I'm wondering is this little
database is capable of handle
Greg Obleshchuk wrote:
>Hello,
>I had this guy email me about a problem about using ISO8859 character .
He
>has this in the DB
>Handhilfsbetätigungssatz
>
>but when queried using my wrapper it returns Handhilfsbet..tigungssatz
>
>When using SQLITE.EXE the results are displayed fine. When I
HI all,
I have / trying to port SQLite to VxWorks . But am having some
problems with the following functions
in file util.c
sqliteSetString() and sqliteSetNString() . When i try to create a database
for the first time i.e. i call sqlite_open() the following function gets
called
Hello,
I had this guy email me about a problem about using ISO8859 character . He
has this in the DB
Handhilfsbetätigungssatz
but when queried using my wrapper it returns Handhilfsbet..tigungssatz
When using SQLITE.EXE the results are displayed fine. When I debug the code
the char *
21 matches
Mail list logo