"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:
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
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"
Date: Fr
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 Nabble
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 in
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
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), datet
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 comp
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 s
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
>
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
http://sqlite.org:8080/cgi-bin/mailman/
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 a
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 thi
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"
Date: F
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 fail
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 grou
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);
>
> w
On Sep 19, 2008, at 6:30 PM, D. Richard Hipp wrote:
>
> 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,
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 = player.id
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, tow
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 i
21 matches
Mail list logo