Re: [sqlite] Can SQLite take advantage of multiple CPU's and/ormultiple cores?

On Friday 19 September 2008 09:50:53 Igor Tandetnik wrote: > <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > Can SQLite take advantage of multiple CPU's and/or multiple > > cores? > > Not automatically: SQLite API functions run on whatever thread you call > them on. Of course,

Re: [sqlite] Can SQLite take advantage of multiple CPU's and/ormultiple cores?

<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Can SQLite take advantage of multiple CPU's and/or multiple > cores? Not automatically: SQLite API functions run on whatever thread you call them on. Of course, you can create multiple threads and open multiple SQLite connections -

Re: [sqlite] Can SQLite take advantage of multiple CPU's and/or multiple cores?

On 9/18/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Can SQLite take advantage of multiple CPU's and/or multiple > cores? > Thank you, > Malcolm I probably don't know what I am talking about, but my sense is that SQLite itself can't, or rather, isn't designed to work that way. On the

[sqlite] Can SQLite take advantage of multiple CPU's and/or multiple cores?

Can SQLite take advantage of multiple CPU's and/or multiple cores? Thank you, Malcolm ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Vista frustrations

The SQLite part was an analogy. That must have been beyond you. You can have the last word. You're beyond my help. Fred Williams wrote: > I never said a word aboout SQLite. You ass U Me too much I suspect. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]

Re: [sqlite] Vista frustrations

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jay A. Kreibich wrote: > SQLite is not "lying." After poking around a bit to refresh my > understanding of SQLite's file structure, I think it is safe to say > that SQLite will almost never do a sequential file read, even if > you're doing a

Re: [sqlite] newbie problem with select statement using 'AND'

It's very strange. I used your example but I still get the same problem. I think I'll try this on a different machine tomorrow. P Kishor-3 wrote: > > here is my simple test that works fine for me -- > > -- db -- > > [05:38 PM] ~/Sites/test$sqlite3 foo > SQLite version

Re: [sqlite] newbie problem with select statement using 'AND'

here is my simple test that works fine for me -- -- db -- [05:38 PM] ~/Sites/test$sqlite3 foo SQLite version 3.5.9 Enter ".help" for instructions sqlite> .s CREATE TABLE members (userID INTEGER PRIMARY KEY, userName TEXT, userOccupation TEXT); sqlite> SELECT * FROM

Re: [sqlite] newbie problem with select statement using 'AND'

On 9/18/08, hugh11 <[EMAIL PROTECTED]> wrote: > > Hi P Kishor-3 > Thanks for your reply. I have altered my script according to your > recommendation, unfortunately the problem remains. I have also used the > eval{ } function to capture the log messages. The log said "no such column: >

Re: [sqlite] newbie problem with select statement using 'AND'

Hi P Kishor-3 Thanks for your reply. I have altered my script according to your recommendation, unfortunately the problem remains. I have also used the eval{ } function to capture the log messages. The log said "no such column: userOccupation(1)" Not sure why it should append (1) to my column

Re: [sqlite] newbie problem with select statement using 'AND'

On 9/18/08, hugh11 <[EMAIL PROTECTED]> wrote: > > I'm using sqlite for my perl cgi website but I've got a problem with the > following select statement... > > SELECT userID FROM members WHERE userName='John' AND > userOccupation='Carpenter' > > Yet if I input this statement from the

[sqlite] newbie problem with select statement using 'AND'

I'm using sqlite for my perl cgi website but I've got a problem with the following select statement... SELECT userID FROM members WHERE userName='John' AND userOccupation='Carpenter' Yet if I input this statement from the sqlite3 command prompt it works! The problem seems to be with the 'and',

Re: [sqlite] Looong sql queries (>9 seconds)

Actually I think you can drop the index on just rate. On Thu, Sep 18, 2008 at 3:12 PM, John Stanton <[EMAIL PROTECTED]> wrote: > I would get rid of your separate columns for day, month and year and use > the Sqlite date format and use an index on it. > > chris wrote: >> I'm at a loss and need

Re: [sqlite] Vista frustrations

I never said a word aboout SQLite. You ass U Me too much I suspect. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Spiegel Sent: Thursday, September 18, 2008 11:25 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Vista frustrations

Re: [sqlite] Looong sql queries (>9 seconds)

I would get rid of your separate columns for day, month and year and use the Sqlite date format and use an index on it. chris wrote: > I'm at a loss and need some guidance. My queries are taking way longer than > I can use but I'm not sure what steps to take next. > > I'm using SQLite 3.6.2

Re: [sqlite] Looong sql queries (>9 seconds)

On Thu, Sep 18, 2008 at 11:58 AM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > On Sep 18, 2008, at 12:46 PM, chris wrote: > > I'm at a loss and need some guidance. My queries are taking way longer >> than I can use but I'm not sure what steps to take next. >> >> >> Try this and see if it

Re: [sqlite] [?? Probable Spam] Re: Vista frustrations

Virgilio Alexandre Fornazin pisze: > Sure. I just tell to do this test to check if the bug is related to this > component, since it debuted on Vista. > Silly thought,but could it be related to database file extension ? I mean , is it possible that OS is caching some files depending on

[sqlite] Static embedding sqlite and compiling in gcc

> icantthinkofone wrote: > > >I lost my note on what I did to make this work. I've rearranged my > >computers for work and installed sqlite3 on Ubuntu. When I installed > >sqlite3, I did ./configure --disable-shared. When I recompile my working > >code on the new machine: > >gcc -static

Re: [sqlite] Looong sql queries (>9 seconds)

Try creating an index on settings(rate) On Thu, Sep 18, 2008 at 12:46 PM, chris <[EMAIL PROTECTED]> wrote: > I'm at a loss and need some guidance. My queries are taking way longer than > I can use but I'm not sure what steps to take next. > > I'm using SQLite 3.6.2 on a small reasonable

Re: [sqlite] Program is crashed on sqlite3_finalize(pStmt);

Thanks Robert!   > So your solution is to NULL your pointer after calling finalize() and don't > call finalize() again if your pointer is NULL. I think I need to do so. Again thanks, JP - Original Message From: Robert Simpson <[EMAIL PROTECTED]> To: General Discussion of SQLite

[sqlite] Looong sql queries (>9 seconds)

I'm at a loss and need some guidance. My queries are taking way longer than I can use but I'm not sure what steps to take next. I'm using SQLite 3.6.2 on a small reasonable powerful embedded platform with 256M ram. I'm using Python to access the database. I've created a very simple database

Re: [sqlite] Vista frustrations

I'm sorry, I have to take issue with that statement. The design of the file system/cache manager is not "pitiful". It strives to provide good performance in the entire application space, not just your little corner of it. It is doing the best it can with the "hint" you've given it. If

Re: [sqlite] Vista frustrations

Designing operating systems is hard work, and I don't envy the teams that do it. I've found my Vista experience to be rather enjoyable, especially post SP1. I don't think there's an OS out today that isn't annoying in one fashion or another. Having an application or library implement a

Re: [sqlite] Program is crashed on sqlite3_finalize(pStmt);

Or to simply not release the same resource twice. That is clearly a bug - the control flow in your application is incorrect if it does this. You could work around it with the NULL value hack if you're short on time, but I recommend trying to find out why this happens since bugs like these

Re: [sqlite] Program is crashed on sqlite3_finalize(pStmt);

You can't. The memory pStmt points to is freed and invalid after the call to finalize. Worse, that freed memory could've already been reallocated for some other purpose by the time the call to finalize() returns control to you. So your solution is to NULL your pointer after calling finalize()

Re: [sqlite] Vista frustrations

Is a sad day when an application program is forced to compensate for pitiful OS design and performance :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Simpson Sent: Thursday, September 18, 2008 10:31 AM To: 'General Discussion of SQLite Database'

Re: [sqlite] Program is crashed on sqlite3_finalize(pStmt);

Hi All, How to check if the pStmt is not finalize so sqlite3_finalize(pStmt) can be call again. I think I called sqlite3_finalize(pStmt) twice so my application is crashed. Thanks, JP - Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Database

Re: [sqlite] Vista frustrations

FILE_FLAG_RANDOM_ACCESS and FILE_FLAG_SEQUENTIAL_SCAN are hints to the cache manager (CC) in Windows and the underlying file system(s). With respect to the cache manager, it is going to affect whether or not there is read ahead, how much read ahead will be used, and how long data will remain

Re: [sqlite] INTEGER store size

On Thu, Sep 18, 2008 at 04:58:35PM +0300, Nick Shaforostoff scratched on the wall: > Hi. I'm deciding between having several INTEGER fields and only one, > which is a bit combination (i'd access it using e.g. main.bits&0x0011, > main.bits&0x0100 and so on). > > The docs say "INTEGER. The value

[sqlite] Triggers on attached databases

Hello all, Is it possible to create a trigger on an attached database? I can't seem to, so I was wondering whether my trigger SQL is wrong (although it works if I remove the attached database's name from the table). The only other way that I see to do what I need would be to create temporary

[sqlite] pagecache?

Hi list, I'm trying to get sqlite to utilize the pagecache and scratch buffers. But when the code exits it returns pagecache overflow and scratch buffer overflow . The to configure the pagecache and scratch are done in the main section of code  as follows: Then connections to sqlite are made

[sqlite] Triggers on attached databases

Hello all, Is it possible to create a trigger on an attached database? I can't seem to, so I was wondering whether my trigger SQL is wrong (although it works if I remove the attached database's name from the table). The only other way that I see to do what I need would be to create temporary

Re: [sqlite] Static embedding sqlite and compiling in gcc

icantthinkofone wrote: >I lost my note on what I did to make this work. I've rearranged my >computers for work and installed sqlite3 on Ubuntu. When I installed >sqlite3, I did ./configure --disable-shared. When I recompile my working >code on the new machine: >gcc -static -L/usr/local/lib