Re: [sqlite] Multiple Match statements per query

Database abstraction, scope, multi-threading. A few stack layers out is my loop requesting each record by rowid. And there's no predicting which thread will make the request. Likely, there will be 50 threads making very similar requests at the same time. If I could clone the statement, then

Re: [sqlite] Multiple Match statements per query

On 4/19/2011 6:57 PM, Dave White wrote: > So, if I could prepare the statement once, then clone it every time I > need to use it, I may see a 4 fold speed increase when calling this > operation frequently. Why can't you just reuse the same statement every time? Are you aware of sqlite3_reset ?

Re: [sqlite] Multiple Match statements per query

I'll look into GLOB. For the statement cloning, I'm looking for something a little different. I already have the connection and query string, and duplicating bindings is not necessary. It's the sqlite3_stmt that I want. right after sqlite3_prepare_v2 has been called. I was doing some

Re: [sqlite] Multiple Match statements per query

On Tue, 19 Apr 2011 14:18:05 -0600 Dave White wrote: > For example, this works: > SELECT T01_fts.docid FROM T01_fts JOIN T01 ON T01_fts.docid = T01.rowid > WHERE T01.hasPic = 0 AND T01_fts.words MATCH 'SBNTKN*' > > These do not: > SELECT T01_fts.docid

Re: [sqlite] installing sqlite

SQLite Manager for firefox has real problems.  I made it work for a while until I found a real GUI. And does a pretty decent job. SQLite Expro Personal is FREE. Of course, there is also a paid version with some additional features. http://www.sqliteexpert.com/ --- On Tue, 4/19/11, Kees Nuyt

Re: [sqlite] installing sqlite

On Tue, 19 Apr 2011 15:04:31 -0400, Carlos Contreras wrote: >sqlite offer a very eficient program but I dont understand how to install it >in my Windows NT PC. I dont know how to compile a C program and then use it >as a shell to run the sqlite commands. > >Can you help

Re: [sqlite] Building managed only System.Data.SQLite

Daniel: I have not tried Csharp-sqlite, it looks interesting but I do not know if that is right for me at this moment. Shane: I will try what you recommend tomorrow, thank you. -- Rich On Tue, Apr 19, 2011 at 4:47 PM, Shane Harrelson wrote: > The target build

Re: [sqlite] Building managed only System.Data.SQLite

The target build settings can be controlled from SQLite.NET.Settings.targets - in particular, you should probably look at UseInteropDll and UseSqliteStandard. To override the USE_INTEROP_DLL setting, try copying SQLite.NET.Settings.targets to SQLite.NET.Settings.targets.user and make the settings

[sqlite] Multiple Match statements per query

It appears that I cannot use MATCH more than once per query. It also looks like I can't use it if prefaced with OR or NOT. For example, this works: SELECT T01_fts.docid FROM T01_fts JOIN T01 ON T01_fts.docid = T01.rowid WHERE T01.hasPic = 0 AND T01_fts.words MATCH 'SBNTKN*' These do

Re: [sqlite] Building managed only System.Data.SQLite

Have you tried C# SQLite? http://code.google.com/p/csharp-sqlite/ --- On Tue, 4/19/11, Rich Rattanni wrote: > From: Rich Rattanni > Subject: [sqlite] Building managed only System.Data.SQLite > To: "General Discussion of SQLite Database"

[sqlite] Building managed only System.Data.SQLite

I was wondering if anyone has had any luck building the Managed-Only System.Data.SQLite .NET adapter for SQLite from the source provided at system.data.sqlite.org? I downloaded the pre-built binaries but they appear to rely on the InterOp assembly. My current project is running under Linux 2.6

[sqlite] installing sqlite

sqlite offer a very eficient program but I dont understand how to install it in my Windows NT PC. I dont know how to compile a C program and then use it as a shell to run the sqlite commands. Can you help me? -- Carlos Contreras, presidente Club Científico de Peñalolén, Santiago, CHILE

[sqlite] What happens if you insert more than your RAM

>Tue Apr 19 18:35:27 GMT 2011 Danny dragonslayer2k at yahoo.com > >Depends on access type.  If accessing sequentially, paging would be minimal, >that is, you would process the "segment" that fits into memory, then page >in another "segment" and process that, etc., etc. Even so it would now be

Re: [sqlite] What happens if you insert more than your RAM

Depends on access type. If accessing sequentially, paging would be minimal, that is, you would process the "segment" that fits into memory, then page in another "segment" and process that, etc., etc. However completely random hits on the database could result in heavy paging, unless it were

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

> What happens if you insert more than your RAM size into an in memory > database? > (I'm particularly interested in the Windows context). > Are we talking about 32bit windows? I mean under 32 bit windows the normal address space limit (without the /3GB switch and LARGEADDRESSAWARE link flag) is

[sqlite] What happens if you insert more than your RAM

Wouldn't it page to disk, thrash and be very slow first?  >On Mon, 18 Apr 2011 09:46:44 -0400, Pavel Ivanov wrote: >You won't be able to insert. The statement will fail. > >On Mon, Apr 18, 2011 at 9:44 AM, Adam DeVita wrote: >> Good day, >> >> What

[sqlite] Building sqlite for windows in a proper way

>On Mon, Apr 18, 2011 at 8:42 AM, Kuba Nowak wrote: > >Does anyone one know how to build sqlite to get the same binary as on >download page ? > What do you use to compare the speed between the builds of SQLite? Are using debug build from VS2010?  My experience is that VS debug builds run most

Re: [sqlite] insert help

On 4/19/2011 1:59 PM, vquickl27 wrote: > Jean-Christophe Deschamps-3 wrote: >> So you need to perform as many inserts as values you have to insert: >> insert into mytable (date, value) values ('2011/04/18 21:35:33', 1); >> insert into mytable (date, value) values ('2011/04/18 21:35:33', 2); >>

Re: [sqlite] insert help

Jean-Christophe Deschamps-3 wrote: > > >>My date column is set when the program starts and i do not want it to >>change. > > How is this date column set in the database without inserting anything? > >> So I have my with and two columns and >>. I have say 5 values (1 2 3 4 5) that I

Re: [sqlite] insert help

>My date column is set when the program starts and i do not want it to >change. How is this date column set in the database without inserting anything? > So I have my with and two columns and >. I have say 5 values (1 2 3 4 5) that I wanted inserted >into mytable where the date is equal

Re: [sqlite] SQLite3.DLL 3.7.6 memory leaks

Are you sure these leaks aren't yours? Although I don't know the Sqlite internals some of the data values don't seem to be related to Sqlite, like: c:/DEV/Platform/ PolicyDataPack.i You can try to use the allocation number to narrow down the code location. Don't remember the specifics though.

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

On Tue, Apr 19, 2011 at 03:29:42PM +0100, Simon Slavin scratched on the wall: > > On 19 Apr 2011, at 2:58pm, Adam DeVita wrote: > > > Our application is typically implemented on a standard laptop PC. It seems > > that the symptoms displayed are consistent with what this list describes > > would

Re: [sqlite] insert help

Jean-Christophe Deschamps-3 wrote: > > >>Newbie here. i'm trying to insert multiple values into a table by a >>certain >>date and when I use where clause it fails. This is my code "insert >>into db >>(table) values ('value') where date = 'date range'". Thanks for any help. > > There is

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

On 19 Apr 2011, at 2:58pm, Adam DeVita wrote: > Our application is typically implemented on a standard laptop PC. It seems > that the symptoms displayed are consistent with what this list describes > would happen, so it looks like I can start thinking of how to write a > defence. It does

Re: [sqlite] Building sqlite for windows in a proper way

> Does anyone one know how to build sqlite to get the same binary as on > download page ? Did you try to remove all those defines that you add at build time and leave only default values set inside sqlite3.c file? Pavel On Mon, Apr 18, 2011 at 8:42 AM, Kuba Nowak wrote:

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

Thanks for the responses. Our application is typically implemented on a standard laptop PC. It seems that the symptoms displayed are consistent with what this list describes would happen, so it looks like I can start thinking of how to write a defence. It does suddenly become very slow. I

Re: [sqlite] SQLITE_MISUSE error code

On Tue, Apr 19, 2011 at 04:19:55PM +0530, Navaneeth Sen B scratched on the wall: > What is this SQLITE_MISUSE error code? When is it exactly thrown? It means that the programmer is using the SQLite API incorrectly, and that there is a fundamental flow or logic issue in the code. An

[sqlite] How to download precompiled files for 3.6.21-x86-Windows

Hi all, We want to upgrade our SQLite version to 3.6.21. But, I could not find any amalgamation or precompiled download link for that version in official website. Therefore, I am requesting a download link where I can verify hashcodes. I need below files: sqlite3.dll sqlite3.lib. sqlite3.h

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

Talking as a Windows user only rather than an SQL expert (I'm not even good enough to call myself a beginner!) Are we talking about a small netbook type with only say 8GB of memory and no hard drive. If a Windows m/c has a hard drive, surely virtual memory (drive-swapping) comes into play? It

[sqlite] SQLite3.DLL 3.7.6 memory leaks

Hi, My name is Khanh Nguyen and currently using SQLite3.DLL 3.7.6 in my application (DLL built with VS2008 C++ with this flag: Multi-threaded Debug DLL (/MDd). The DLL has some memory leaks that I have captured here: The thread 'Win32 Thread' (0x368) has exited with code 0 (0x0).

[sqlite] SQLITE_MISUSE error code

Hi All, What is this SQLITE_MISUSE error code? When is it exactly thrown? -- Thanks, Sen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [SQLITE] precompiled files for 3.6.21-x86-Windows

Hi all, We want to upgrade our SQLite version to 3.6.21. But, I could not find any amalgamation or precompiled download link for that version in official website. Therefore, I need your help to find a download link where I can verify hashcodes. I need below files: sqlite3.dll sqlite3.lib

Re: [sqlite] insert help

>Newbie here. i'm trying to insert multiple values into a table by a >certain >date and when I use where clause it fails. This is my code "insert >into db >(table) values ('value') where date = 'date range'". Thanks for any help. There is no where clause in insert statements, it wouldn't