--- proxi...@land.ru wrote:
From: Michael
To: sqlite-users@sqlite.org
Subject: [sqlite] double calculation in SELECT
Date: Sun, 04 Oct 2009 15:31:47 +0700
Hello,
I have following SELECT statement in my program (Delphi+sqlite3):
On 4 Oct 2009, at 6:11pm, Cory Nelson wrote:
> On Fri, Oct 2, 2009 at 12:34 PM, Cory Nelson
> wrote:
>> On Fri, Oct 2, 2009 at 9:45 AM, Francisc Romano
>> wrote:
>>> Wow. I did not expect such a quick answer...
>>> Is there somewhere I can read exactly how fast and how big
>>> databases S
On 4 Oct 2009, at 7:08pm, Roger Binns wrote:
> SQLite is used in Firefox for history and benchmarks. Why not
> extrapolate
> from the queries in the Firefox source code?
Also relevant: HTML5 gives Web JavaScript the ability to do SQL. If I
recall correctly both FireFox and WebKit (i.e. Saf
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matthew Tippett wrote:
> 'How do I determine what impact the host os/environment has on sqlite'.
The very first test should be a sanity check where you do a bunch of inserts
each as their own transaction. Each transaction should require calling
fsy
On Fri, Oct 2, 2009 at 12:34 PM, Cory Nelson wrote:
> On Fri, Oct 2, 2009 at 9:45 AM, Francisc Romano wrote:
>> Wow. I did not expect such a quick answer...
>> Is there somewhere I can read exactly how fast and how big databases SQLite
>> can take, please?
>
> SQLite uses a b+tree internally, whi
Hi Kees,
Thanks for your advice, I am understand now.
Andi
On 10/4/09, Kees Nuyt wrote:
> On Sun, 4 Oct 2009 12:11:52 +0700, Andi Suhandi
> wrote:
>
>>Hi George,
>>
>>
>>Thanks for the link
>>(http://www.codeproject.com/KB/database/CppSQLite.aspx) that you gave
>>me, it really help me to start
Thanks Roger.
I understand aspects of your position.
First up, as you imply, there are many cases where people call out
that the sqlite tests are invalid. I would like to shore up against
that by increasing the number of tests and increasing the system
dimension that is tested.
The current test
On Sun, 4 Oct 2009 12:11:52 +0700, Andi Suhandi
wrote:
>Hi George,
>
>
>Thanks for the link
>(http://www.codeproject.com/KB/database/CppSQLite.aspx) that you gave
>me, it really help me to start progamming in C++.
>
>Ok, read the code in http://www.sqlite.org/quickstart.html, but it
>looks like n
Hello,
I have following SELECT statement in my program (Delphi+sqlite3):
_
select
id,power,
(select sum
((strftime("%s",table2.endtime)-strftime("%s",table2.begintime))*table2.power)
from table2 where table1
Hi,
I just noticed by code review small and easy to fix bug in -vfs option
handling code.
sqlite3 Tcl command line syntax is following:
sqlite3 HANDLE ?FILENAME ?-vfs VFSNAME? ?-readonly BOOLEAN? ?-create
BOOLEAN? ?-nomutex BOOLEAN? ?-fullmutex BOOLEAN?
But if -vfs option is in the middle, the fo
10 matches
Mail list logo