[sqlite] ODBC drivers are faster than NAtive C API why?

[goldy]

Hi all,

I tried to execute some SQL queries using drivers(sqliteodbc) and Native c
API but i found that ODBC drivers are working twice faster than c API.
Why this behavior is coming as c APIs are supposed to be faster than
drivers?
Any thought on this would be appreciated.

Regards
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] how to run speed tests (speedtest.tcl)

[goldy]

Hi,

i tried to run speedtest.tcl as mention in
http://www.sqlite.org/speed.htmlbut i am getting below error:

./testfixture: couldn't execute "./sqlite248": no such file or directory
while executing
"exec ./sqlite248 s2k.db <2kinit.sql"

How to generate sqlite248 ?

Regards
Avinash
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] ODBC test

[goldy]

Hi,

Does there any test case exist for ODBC testing of sqlite, how one can be
sure about sqlite working with ODBC.

Regards
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] self test for sqlite-amalgamation-3.6.5

[goldy]

Hi,

Do we need to add more files in src as i just copied test*.c and *.h files
from source tar and then compiled in 3.6.5-amalgmation .

On Tue, Nov 25, 2008 at 10:21 AM, goldy <[EMAIL PROTECTED]> wrote:

> Hi Shane,
>
> I am using linux and i have used these options:
> gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I./src -DNDEBUG -I/devel/usr/include
> -DSQLITE_THREADSAFE=1 -DSQLITE_THREAD_OVERRIDE_LOCK=-1  -DTCLSH=1
> -DSQLITE_NO_SYNC=1\
> -DSQLITE_CRASH_TEST=1 -DSQLITE_TEST=1\
> -DSQLITE_SERVER=1 -DSQLITE_PRIVATE="" -DSQLITE_CORE
> -DSQLITE_TEMP_STORE=1
>  -o testfixture ./src/test1.c ./src/test2.c ./src/test3.c ./src/test4.c
> ./src/test5.c ./src/test6.c ./src/test7.c ./src/test8.c ./src/test9.c
> ./src/test_autoext.c ./src/test_async.c ./src/test_btree.c
> ./src/test_config.c ./src/test_devsym.c ./src/test_func.c ./src/test_hexio.c
> ./src/test_malloc.c ./src/test_md5.c ./src/test_mutex.c ./src/test_onefile.c
> ./src/test_osinst.c ./src/test_schema.c ./src/test_server.c
> ./src/test_tclvar.c ./src/test_thread.c sqlite3.c -L/devel/usr/lib -ltcl8.4
> -ldl  -lieee -lm -lpthread
>
>
> I have copied src/test*.c from source repository and appended tclsqlite.c
> to sqlite3.c.
>
> I also tried to give -DSQLITE_AMALGAMATION flag but then during compilation
> i am getting errors.
>
> Regards
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] self test for sqlite-amalgamation-3.6.5

[goldy]

Hi Shane,

I am using linux and i have used these options:
gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I./src -DNDEBUG -I/devel/usr/include
-DSQLITE_THREADSAFE=1 -DSQLITE_THREAD_OVERRIDE_LOCK=-1  -DTCLSH=1
-DSQLITE_NO_SYNC=1\
-DSQLITE_CRASH_TEST=1 -DSQLITE_TEST=1\
-DSQLITE_SERVER=1 -DSQLITE_PRIVATE="" -DSQLITE_CORE
-DSQLITE_TEMP_STORE=1
 -o testfixture ./src/test1.c ./src/test2.c ./src/test3.c ./src/test4.c
./src/test5.c ./src/test6.c ./src/test7.c ./src/test8.c ./src/test9.c
./src/test_autoext.c ./src/test_async.c ./src/test_btree.c
./src/test_config.c ./src/test_devsym.c ./src/test_func.c ./src/test_hexio.c
./src/test_malloc.c ./src/test_md5.c ./src/test_mutex.c ./src/test_onefile.c
./src/test_osinst.c ./src/test_schema.c ./src/test_server.c
./src/test_tclvar.c ./src/test_thread.c sqlite3.c -L/devel/usr/lib -ltcl8.4
-ldl  -lieee -lm -lpthread


I have copied src/test*.c from source repository and appended tclsqlite.c to
sqlite3.c.

I also tried to give -DSQLITE_AMALGAMATION flag but then during compilation
i am getting errors.

Regards
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users