Re: [sqlite] cursor question

2006-12-11 Thread Trevor Talbot

On 12/11/06, Jim Crafton <[EMAIL PROTECTED]> wrote:


Does the latest version of sqlite have cursors? If so, where might I
find docs on using them?


No; however, the API returns query results iteratively, as if it were
an implicit forward-only cursor.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] cursor question

2006-12-11 Thread Jim Crafton

Does the latest version of sqlite have cursors? If so, where might I
find docs on using them?

Thanks

Jim C

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] faster SELECT time on second run

2006-12-11 Thread John Stanton
Use a Unix read or a Windows API ReadFile and read the whole file in one 
call.  Find the size of it using a Unix lseek or Win32 API GetFileSize 
call.  You will certainly pull the whole file into VM that way.


Jay Sprenkle wrote:

On 12/11/06, Dennis Cote <[EMAIL PROTECTED]> wrote:



Simply read the entire file once using fread when you open the database.
That will load the entire file in to the OS cache so that when SQLite
starts reading the file, the required disk blocks are already in memory.
The result is the same fast lookups that you see in SQLite the second
time you run a query. The additional read is also quite fast since it
reads the file sequentially from start to finish with no seeking,
whereas SQLite will seek back and forth as it reads database pages into
memory.



You probably can't fseek() to the end and get the same effect?

You could do this in vb6 by writing a loop and using "input #1"
and discarding what was read. In vb.net it's much simpler using
a file stream reader.

--
The JS Image Collector suite:
http://groups-beta.google.com/group/js-image-collector?hl=en

SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 






-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] faster SELECT time on second run

2006-12-11 Thread Jay Sprenkle

On 12/11/06, Dennis Cote <[EMAIL PROTECTED]> wrote:


Simply read the entire file once using fread when you open the database.
That will load the entire file in to the OS cache so that when SQLite
starts reading the file, the required disk blocks are already in memory.
The result is the same fast lookups that you see in SQLite the second
time you run a query. The additional read is also quite fast since it
reads the file sequentially from start to finish with no seeking,
whereas SQLite will seek back and forth as it reads database pages into
memory.


You probably can't fseek() to the end and get the same effect?

You could do this in vb6 by writing a loop and using "input #1"
and discarding what was read. In vb.net it's much simpler using
a file stream reader.

--
The JS Image Collector suite:
http://groups-beta.google.com/group/js-image-collector?hl=en

SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] locking problem under windows

2006-12-11 Thread Trevor Talbot

On 12/11/06, "LEGRAND, Véronique" <[EMAIL PROTECTED]> wrote:


I found in the sqlite3 documentation that there were locking problems when
several processes running on different machines where trying to access an
sqlite3 database located on an NFS filesystem and that this problem could be
solved by running the "nfslockd" daemon.

As I encounter the same problem on windows NTFS filesystem, I was woundering
if there was an equivalent of "nfslockd" under windows?


This applies to NFS servers, to supply locking semantics across the
network.  NTFS is only relevant for the local machine only, for which
locking works fine.  If you're exporting things via CIFS/SMB shares
from a Windows server, locking is handled.  If you're doing it from
samba, locking may or may not work.

What is your setup?

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] SQLite for .NET 1.1?

2006-12-11 Thread Robert Simpson
> -Original Message-
> From: jfbaro [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 11, 2006 1:58 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] SQLite for .NET 1.1?
> 
> 
> Hi!
> 
> Where can we find ADO for .NET 1.1?

http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

Robert





-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Conector for ADO .NET 1.1??

2006-12-11 Thread Jean Fautrix
Hi!

We have been developing for .NET 2.0 (c#), but now we need to use SQLite 3.0 
along with .NET 1.1!

We have tried to find something, but we didn't succed!

Is there any one here who knows about where we could find a .NET 1.1 version of 
ADO provider??

Thanks in advance





___ 
Novidade no Yahoo! Mail: receba alertas de novas mensagens no seu celular. 
Registre seu aparelho agora! 
http://br.mobile.yahoo.com/mailalertas/ 
 


[sqlite] SQLite for .NET 1.1?

2006-12-11 Thread jfbaro

Hi!

Where can we find ADO for .NET 1.1?

Thanks in advance
-- 
View this message in context: 
http://www.nabble.com/SQLite-for-.NET-1.1--tf2796567.html#a7802832
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] windows dll

2006-12-11 Thread Pat Wibbeler
All static goodness aside, I think the OP's question is still
reasonable.  The best suggestion I've heard for those who want to
version the DLL is to do it themselves, but  many feel much more
comfortable with a project-approved binary.  Perhaps someone who feels
strongly enough about a versioned DLL could post a patch to the build
and propose having it added to the distribution.

Pat

-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 11, 2006 12:12 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] windows dll

I agree with you 100%.  Statically linking Sqlite to applications gives 
you some freedom from "DLL HELL" and "REV LOCK SHOCK" and can only 
result in inefficiency if you have multiple different application 
programs using Sqlite on the individual workstation.

To my way of implementing KISS, using an Sqlite DLL makes no sense.

Teg wrote:
> Hello Art,
> 
> I don't depend on the DLL version because I compile SQLite in. There's
> never an issue. Why not generate your own DLL and include the version
> information? You can then rename the DLL so, you're not competing with
> other versions of the DLL.
> 
> These days, I'd rather have a larger executable that I know works
> everywhere and doesn't depend on DLL versioning.
> 
> C
> 
> Sunday, December 10, 2006, 12:31:33 PM, you wrote:
> 
> A> is there a reason that the version information cannot be
> A> included in the resource of the windows dll?  its not easy to
> A> cleanup a system that you might encounter or have to debug aa
> A> product installation on if there's multiple versions of sqlite3.dll
> A> on a user's system without any version resource information
> A> available in the dll.  this is standard practice to include this
> A> information.
> 
> A> thank you
> 
> 
> A> Thank you, 
> 
> A> Art Zerger
>  
> A> [EMAIL PROTECTED]
>  
> 
> 
>  
> A> -
> A> Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call
rates.
> 
> 
> 



-
To unsubscribe, send email to [EMAIL PROTECTED]

-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] windows dll

2006-12-11 Thread John Stanton
I agree with you 100%.  Statically linking Sqlite to applications gives 
you some freedom from "DLL HELL" and "REV LOCK SHOCK" and can only 
result in inefficiency if you have multiple different application 
programs using Sqlite on the individual workstation.


To my way of implementing KISS, using an Sqlite DLL makes no sense.

Teg wrote:

Hello Art,

I don't depend on the DLL version because I compile SQLite in. There's
never an issue. Why not generate your own DLL and include the version
information? You can then rename the DLL so, you're not competing with
other versions of the DLL.

These days, I'd rather have a larger executable that I know works
everywhere and doesn't depend on DLL versioning.

C

Sunday, December 10, 2006, 12:31:33 PM, you wrote:

A> is there a reason that the version information cannot be
A> included in the resource of the windows dll?  its not easy to
A> cleanup a system that you might encounter or have to debug aa
A> product installation on if there's multiple versions of sqlite3.dll
A> on a user's system without any version resource information
A> available in the dll.  this is standard practice to include this
A> information.

A> thank you


A> Thank you, 


A> Art Zerger
 
A> [EMAIL PROTECTED]
 



 
A> -

A> Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates.






-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] locking problem under windows

2006-12-11 Thread LEGRAND, Véronique
I found in the sqlite3 documentation that there were locking problems when
several processes running on different machines where trying to access an
sqlite3 database located on an NFS filesystem and that this problem could be
solved by running the "nfslockd" daemon.

As I encounter the same problem on windows NTFS filesystem, I was woundering
if there was an equivalent of "nfslockd" under windows?

Has anyone heard about that or must I give up using sqlite3 under such
condition?

 

Thank you in advance for any answer.



Re: [sqlite] faster SELECT time on second run

2006-12-11 Thread bartsmissaert
> using fread

Not sure how to do that with my VB wrapper.
At work now, so can't see, but will give it a try.

RBS

> RB Smissaert wrote:
>> Can't think of any code for that :)
>>
>>
>>
>>
>> you could prefetch data if you can predict what users will search for
>> ;)
>>
>>
> Actually, you don't need to predict the users actions if your database
> isn't too large.
>
> Simply read the entire file once using fread when you open the database.
> That will load the entire file in to the OS cache so that when SQLite
> starts reading the file, the required disk blocks are already in memory.
> The result is the same fast lookups that you see in SQLite the second
> time you run a query. The additional read is also quite fast since it
> reads the file sequentially from start to finish with no seeking,
> whereas SQLite will seek back and forth as it reads database pages into
> memory.
>
> HTH
> Dennis Cote
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>
>




-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] sqlite3 close() run time errors

2006-12-11 Thread Roberto

You are probably linking against exports with a leading underscore.
(The exports of sqlite3.dll don't have the _underscore). Does your dev
environment/linker have the option to disable this underscore
generation?

On 11/12/06, Michele Santucci <[EMAIL PROTECTED]> wrote:

Hello,

I'm trying to use sqlite3 into a CVI (National Itruments ANSI C dev tool). I 
took the last sqlite3 dll and source.
I create the .lib file linked it to the binary and included the sqlite3.h 
file... but as long as I start the application I got an error about a missing 
entry point of the _sqlite3_close() function... why?
May depends on mscvrt dependancies?

Distinti saluti,

 Michele Santucci
=
Software Development Manager
*
Celin Avio s.r.l.
*
tel. +39-0187933876
fax +39-0187933654
web: http://www.celinavio.it
=



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] sqlite3 close() run time errors

2006-12-11 Thread Marten Feldtmann

Michele Santucci schrieb:

Hello,

I'm trying to use sqlite3 into a CVI (National Itruments ANSI C dev tool). I 
took the last sqlite3 dll and source.
I create the .lib file linked it to the binary and included the sqlite3.h 
file... but as long as I start the application I got an error about a missing 
entry point of the _sqlite3_close() function... why?
  
Calling convention and name decoration. Your linker knows, that 
sqlite3_close() has to be called via cdecl
calling convention and does not look for sqlite_close(), but for 
_sqlite_close().


You have to tell your IDE, Linker - that it should not use naming 
decoration.


Marten

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] sqlite3 close() run time errors

2006-12-11 Thread Michele Santucci
Hello,

I'm trying to use sqlite3 into a CVI (National Itruments ANSI C dev tool). I 
took the last sqlite3 dll and source.
I create the .lib file linked it to the binary and included the sqlite3.h 
file... but as long as I start the application I got an error about a missing 
entry point of the _sqlite3_close() function... why?
May depends on mscvrt dependancies?

Distinti saluti,

 Michele Santucci
=
Software Development Manager
*
Celin Avio s.r.l.
*
tel. +39-0187933876
fax +39-0187933654
web: http://www.celinavio.it
=