Hello,
I am using the SQLite for the database support in my application.
Does anyone has encountered this problem of openVB() function getting failed
when trying to create a new
Database file. Basically the actual error I am getting is
"QueryInterface for interface DSSQLiteWrap.ISQLi
On 6/23/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
DK wrote:
>
> Well postfix when mail arrives checks if the to field of the email
> matches up with any users aliases. One user can have many aliases as
> in [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
> but also [EMAIL PROTECTED], [EM
> On 23 Jun 2006, at 14:16, Dennis Cote wrote:
> > Most of SQLite's disk I/O is actually going to the memory used for
> > the operating system's disk cache, not directly to the disk. Hence
> > its speed is not much different when using a disk based database
> > than a memory based database. I
--- Manzoor Ilahi Tamimy <[EMAIL PROTECTED]> wrote:
> DISK MODE
> 3000 000 INSERTS 31 Seconds 96774 INSERTS / Sec
> "SELECT * from t" 5 Seconds.
>
> MEMORY MODE
> 3000 000 INSERTS 53 Seconds 56604 INSERTS / Sec
> "SELECT * from t" 5 Seconds.
>
> Can I reduce the TIME of DISK mode or t
On 23 Jun 2006, at 14:16, Dennis Cote wrote:
John Stanton wrote:
Cacheing will drive you crazy.
Very well put.
Most of SQLite's disk I/O is actually going to the memory used for
the operating system's disk cache, not directly to the disk. Hence
its speed is not much different when using
John Stanton wrote:
Cacheing will drive you crazy.
Very well put.
Most of SQLite's disk I/O is actually going to the memory used for the
operating system's disk cache, not directly to the disk. Hence its speed
is not much different when using a disk based database than a memory
based databa
[EMAIL PROTECTED] wrote:
It is more complicated on windows.
Richard,
I use MinGW/MSYS to build on windows. I also have ActiveTCL installed. I
make and run the quick test using the makefile generated by the
configure script.
../sqlite/configure --with-tcl=/c/TCL/lib
make test
This will b
Gerry Snyder wrote:
BTW, I really liked the video presentation mentioned on the list
recently, not least because I had not been sure how to pronounce
SQLite (I had thought it might be ESS CUE LITE instead of the proper
ESS CUE ELL (L)ITE)
Well, that's really only one person's opinion of how
DK wrote:
Well postfix when mail arrives checks if the to field of the email
matches up with any users aliases. One user can have many aliases as
in [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
but also [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED] these are all aliases whic
So...
sqlite-3.3.5
Would you expect ./testfixture ./test/quick.test to pass with "0 errors out
of 24922 tests"
But ./testfixture ./test/all.test to bail abruptly with:
btree2-2.5... Ok
btree2-2.6...
Error: invalid command name "btree_cursor_info"
btree2-2.7... Ok
btree2-2.8.1.0... Ok
/opt/alar
"Frank Gordon" <[EMAIL PROTECTED]> wrote:
> I'm a newbie. I am also a test engineer interested in the amount and types
> of testing that are performed on SQLite. Especially on releases of new
> versions.
> Can anyone shed any light on this topic?
>
> I have spent a considerable amount of days lo
I'm a newbie. I am also a test engineer interested in the amount and types
of testing that are performed on SQLite. Especially on releases of new
versions.
Can anyone shed any light on this topic?
I have spent a considerable amount of days looking for SQLite regression
tests that are available,
[EMAIL PROTECTED] wrote:
http://www.sqlite.org/cvstrac/wiki?p=VirtualTables
This is a feature currently under active development.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Wow!
I really look forward to the day when this and full-text search are
ready for prime-time use (including accessibil
On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
DK <[EMAIL PROTECTED]> wrote:
> On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > DK <[EMAIL PROTECTED]> wrote:
> > > There is data like email aliases which need to be accessed by the MTA.
> > > It wouldn't be a good idea to open
Cacheing will drive you crazy.
CARTER-HITCHIN, David, GBM wrote:
This is a modified version of the test code I posted to show
that there
was a small but definite SLOWDOWN when using :memory:
databases compared
to a database in a file on disk. It seems strange, but it is
true. Use a
disk
DK <[EMAIL PROTECTED]> wrote:
> On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > DK <[EMAIL PROTECTED]> wrote:
> > > There is data like email aliases which need to be accessed by the MTA.
> > > It wouldn't be a good idea to open each users db to check the aliases
> > > for each email th
At 03:09 23/06/2006, you wrote:
#include "stdafx.h"
<>
samples, t, samples / t);
getch();
//*
Here you should create index for table t. In your previous example, for hvh itm
// Select Time check
//*
On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
DK <[EMAIL PROTECTED]> wrote:
> There is data like email aliases which need to be accessed by the MTA.
> It wouldn't be a good idea to open each users db to check the aliases
> for each email that arrives. So what we would need is a common
> This is a modified version of the test code I posted to show
> that there
> was a small but definite SLOWDOWN when using :memory:
> databases compared
> to a database in a file on disk. It seems strange, but it is
> true. Use a
> disk file for best speed.
If true, this is crazy. Memory
Matthew Jones wrote:
Is there any straight forward way I could use SQLite3 with virtual
tables. By that I mean SQLite contains all the table and index
definitions but none of the data - actually it will contain the data
for some tables but not others. I only need to query access to the
tables
Manzoor Ilahi Tamimy wrote:
I have tested my Code with the following PRAGMA and still not getting any
change in time.
//--
sqlite3_exec(db, "PRAGMA temp_store=2", NULL, NULL, NULL);
sqlite3_exec(db, "PRAGMA synchronous=0", NULL, NULL,
Matthew Jones <[EMAIL PROTECTED]> wrote:
> Is there any straight forward way I could use SQLite3 with virtual
> tables. By that I mean SQLite contains all the table and index
> definitions but none of the data - actually it will contain the data for
> some tables but not others. I only need to q
Hello All,
I have played with the new Virtual Table interface from CVS and found some
shortcommings for the current implementation of the xRowID method:
int (*xRowid)(sqlite3_vtab_cursor*, sqlite_int64 *pRowid);
As far as I understand, this function is called by SQLite whenever it needs a
un
Adam Rodenberger <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I was trying to download this...
>
>
> Cross-Platform Binaries
> sqlite-3_3_6.kit
> (593.03 KiB)A starkit containing precompiled SQLite binaries
> and Tcl bindings for Linux-x86, Windows, and Mac OS-X.
>
> I get the f
Is there any straight forward way I could use SQLite3 with virtual
tables. By that I mean SQLite contains all the table and index
definitions but none of the data - actually it will contain the data for
some tables but not others. I only need to query access to the tables so
I need to intercept
liyan <[EMAIL PROTECTED]> wrote:
> hi, i have the same problem with shibu alampatta.
> As what you say ,how to compile sqlite without tcl?
> Can setting up a new tcl help?
>
Get preprocessed source code from the website:
http://www.sqlite.org/sqlite-source-3_3_6.zip
Unpack the archive. Del
Am 13.06.2006 um 04:14 schrieb PY:
Thanks for you reply.
I Just want to get a sequence number in a view, that is not the ID
field in
the table foo.
Table foo is a sample of mine. In fact, my table is not only the id
and x
field.
And the x field could be duplicate in the table foo.
Cou
Sarah uttered:
Thank you for your advice.
If I skip the functionality of file locking, that is to say, in my
project, I do not need to use the functionality of file locking, then
which approach will be easier for me to wrap my self-defined file system
to a set of standard interfaces?
One
DK <[EMAIL PROTECTED]> wrote:
> There is data like email aliases which need to be accessed by the MTA.
> It wouldn't be a good idea to open each users db to check the aliases
> for each email that arrives. So what we would need is a common db
> which mirrors one table from all the user databases.
Manzoor Ilahi Tamimy wrote:
>sqlite3_exec(db, "create table t (a integer, b float, c text,d integer,
> e float, f text, g float, h text)", NULL, NULL, NULL);
>
>sqlite3_exec(db, "begin transaction", NULL, NULL, NULL);
>
>sqlite3_prepare(db, "insert into t values (?, ?, ?, ?, ?
Fred a wrote:
> Hi,
>
> Thank you for your answer...
> You try to reproduce on win32 or linux ?
> I think, may be, i have a bug on my porting layer (lock file / unlock
> file)...
>
> But without this problem context, can i :
>- open a (new) database
>- insert some records
>-
31 matches
Mail list logo