[sqlite] [3.6.2] "make test" doesn't work on OS X 10.5.5

Looks like "make test" can't links with TCL library: Undefined symbols: "_Tcl_GetIndexFromObjStruct", referenced from: _processDevSymArgs in ccpuPiSI.o _test_config in ccy8gMQR.o "_Tcl_GetInt", referenced from: _test_get_table_printf in ccux7BhL.o _sqlite3_mprintf_int

Re: [sqlite] JOIN works very strange [3.6.2]

I just want to add that this SQL query works great at 3.5.4. And this is explain: addr opcode p1p2p3p4 p5 comment - - -- - 0 Trace 0 0 0 EXPLAIN SELECT town.id,

[sqlite] JOIN works very strange [3.6.2]

Hello everyone, I gets strange result from this query on SQLite-3.6.2 SELECT town.id, town_log.new_player_id, player.name FROM town_log LEFT JOIN town LEFT JOIN player ON town.id = town_log.town_id AND town_log.new_player_id =

Re: [sqlite] Performance/bug in multikey 'group by' in 3.6.2

On Sep 19, 2008, at 5:47 PM, Russ Leighton wrote: > > Observation 1: Group by (in my case) is faster w/out using the index > than with using the index by 10X > > In my app I have a table- > > create table foo(k1integer ,k2 integer,k3 integer,...); > create index foo_idx on foo(k1,k2,k3); > >

[sqlite] Performance/bug in multikey 'group by' in 3.6.2

Observation 1: Group by (in my case) is faster w/out using the index than with using the index by 10X In my app I have a table- create table foo(k1integer ,k2 integer,k3 integer,...); create index foo_idx on foo(k1,k2,k3); when I do- select k1,k2,sum() as s,count(1) as c from foo

[sqlite] mac file locking

I'm experimenting with using networked files as sqlite databases (yes, I'm aware this is a questionable practice) If the client is running on a mac, and the database file is not a local disk, "database locked" error is returned immediately. I assume this means that the file lock mechanism

Re: [sqlite] Core dumps on AIX with optimization

I use sqlite on AIX, but compile using gcc. Can you try the gcc compiler instead? --- On Fri, 9/19/08, Ribeiro, Glauber <[EMAIL PROTECTED]> wrote: From: Ribeiro, Glauber <[EMAIL PROTECTED]> Subject: [sqlite] Core dumps on AIX with optimization To: "General Discussion of SQLite Database"

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

Mohit Sindhwani wrote: > Bogusław Brandys wrote: >> Silly thought,but could it be related to database file extension ? I >> mean , is it possible that OS is caching some files depending on >> extension like it was with Windows XP system restore "feature". >> I know it is almost impossible in

Re: [sqlite] Core dumps on AIX with optimization

We use Sqlite on AIX and discovered that when compiling with gcc we have to remove the debug -g from the makefiles No optimization issues. We always link statically. Ribeiro, Glauber wrote: > Just wondering, are there other AIX Sqlite users out there, and what > have you done in order to get

Re: [sqlite] How to convert any dataType to sqlite3_value ?

suku249 <[EMAIL PROTECTED]> wrote: > I need to convert dataTypes like int or string into sqlite3_value. Why? What are you trying to achieve? Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Between And statement too much slow

Giuseppe Costanzi <[EMAIL PROTECTED]> wrote: > the query look on 16750 record on tblTansactions and return 85 rows > > > sSQL ="""SELECT > tblProducts.ProductName,tblProducts.WarehouseCode,tblProducts.UnitsInStock,SUM(tblTransactions.Quantity) > FROM tblProducts >

Re: [sqlite] Between And statement too much slow

On Fri, Sep 19, 2008 at 12:36 PM, Giuseppe Costanzi <[EMAIL PROTECTED]>wrote: > > How could improve my code? Go into the sqlite3 command line and issue EXPLAIN QUERY PLAN You'll have to fill in some values for the ?s, but that'll give you some hints. Also: How long is "too slow"? Several

[sqlite] Core dumps on AIX with optimization

Just wondering, are there other AIX Sqlite users out there, and what have you done in order to get a successful compile? I found out that on our AIX 5.2, with IBM's Visual Age C v9.0, the command line utility sqlite2 dumps core when running SQL that contains an aggregation function, if it was

[sqlite] Between And statement too much slow

Hi, I'm using this query on my aplication to retrive a recordset that shows transactions between two date. The problem is that it's too much slow. I'm using python and the field TransactionDate is Datetime (e.g. 2008-01-01) and i passed some such parameters ('1', datetime.date(2008, 7, 1),

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

Bogusław Brandys wrote: > 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

Re: [sqlite] Database locking issue

Am 19.09.2008 um 17:03 schrieb Ken: > Try it with the latest full build say version 3.6.2 and see what > happens instead of a "patched" > I'll give that a try. Could the current code be compiled with Open Watcom as A DLL ? (I haven't seen these __declspec(dllexport) and the opposite stuff

[sqlite] How to convert any dataType to sqlite3_value ?

hi, I need to convert dataTypes like int or string into sqlite3_value. Any Idea how to do this? Thanks in advance. -- View this message in context: http://www.nabble.com/How-to-convert-any-dataType-to-sqlite3_value---tp19574177p19574177.html Sent from the SQLite mailing list archive at

Re: [sqlite] Database locking issue

Try it with the latest full build say version 3.6.2 and see what happens instead of a "patched" --- On Fri, 9/19/08, Lothar Behrens <[EMAIL PROTECTED]> wrote: From: Lothar Behrens <[EMAIL PROTECTED]> Subject: [sqlite] Database locking issue To: "General Discussion of SQLite Database"

[sqlite] Database locking issue

Hi, I am using Version 3.5.2 of Sqlite with the changes of the following CVS checkin numbers: 4543 and 5243 to get the sqlite3_sql and sqlite3_next_stmt functions into my API. I have patched my files due to the need to figuring out what statements were unfinalized. But now I get 'database

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

"Graeme" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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: