Alexey Pechnikov wrote:
> Hello!
>
> On Monday 21 September 2009 19:56:07 Igor Tandetnik wrote:
>
>>> Are correct selects like as
>>> SELECT * from tbl_name where date = julianday('now','start of month');
>>>
>> I see no reason why not. Note that the condition will only hold when
>> "dat
On Wed, Sep 23, 2009 at 03:40:33PM -0700, burferd scratched on the wall:
>
> In looking at the reference http://www.sqlite.org/c3ref/free_table.html
> it states that the result is a pointer array that has (rows+1)*columns
> elements.
>
> I pose a query to select items from my database table.
> Th
In looking at the reference http://www.sqlite.org/c3ref/free_table.html
it states that the result is a pointer array that has (rows+1)*columns
elements.
I pose a query to select items from my database table.
The function returns a row value of 5 and column value of 19.
This tells me that there sh
Pavel Ivanov wrote:
>> But after all these years I wonder why they don't fix the fork problem?
>> MacOS runs on Intel processors. Windows runs on Intel processors. Surely
>> they could learn how it *should* be done by studying things like the
>> Open Source Java code?
>
> You seem to forget the ba
Interesting
Mind if we ask what the SSD device brand and model is?
Is it a disk backed type of device with equal memory in front, I recall seeing
devices like this about 7 years ago. I'm thinking that the sync call is causing
the device to write its memory contents back out to disk (ie to b
*slaps self*
Thanks for all the help- can't beleive I was duped by something so
obvious... heh.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello!
On Monday 21 September 2009 19:56:07 Igor Tandetnik wrote:
> > Are correct selects like as
> > SELECT * from tbl_name where date = julianday('now','start of month');
>
> I see no reason why not. Note that the condition will only hold when
> "date" column represents midnight on the corresp
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Andrew wrote:
> I didn't see a way to search the mail archive,
Go to http://sqlite.org/support.html and look in the middle of the page
where it describes the mailing lists. All 3 links to archives take you to
pages that then have an option to search
Andrew wrote:
> I didn't see a way to search the mail archive, so hopefully this
> hasn't been addressed repeatedly in the past...
>
> $ sqlite data.dat
> SQLite version 2.8.17
> Enter ".help" for instructions
> sqlite> .schema
> sqlite> CREATE TABLE IF NOT EXISTS t ( foo int );
> SQL error: near
On Sep 23, 2009, at 2:43 PM, Andrew wrote:
> I didn't see a way to search the mail archive, so hopefully this
> hasn't been
> addressed repeatedly in the past...
>
> $ sqlite data.dat
> SQLite version 2.8.17
> Enter ".help" for instructions
> sqlite> .schema
> sqlite> CREATE TABLE IF NOT EXISTS
I didn't see a way to search the mail archive, so hopefully this hasn't been
addressed repeatedly in the past...
$ sqlite data.dat
SQLite version 2.8.17
Enter ".help" for instructions
sqlite> .schema
sqlite> CREATE TABLE IF NOT EXISTS t ( foo int );
SQL error: near "NOT": syntax error
sqlite>
I d
On Wed, Sep 23, 2009 at 06:12:13PM +0100, Simon Slavin wrote:
>
> On 23 Sep 2009, at 5:12pm, Nicolas Williams wrote:
>
> > On Tue, Sep 22, 2009 at 04:45:31PM -0400, D. Richard Hipp wrote:
> >> UPDATE t1 SET x=x; -- key line: Is this considered an "update"
> >> of t1.x?
> >
> > Igor pointed
On 23 Sep 2009, at 5:12pm, Nicolas Williams wrote:
> On Tue, Sep 22, 2009 at 04:45:31PM -0400, D. Richard Hipp wrote:
>> UPDATE t1 SET x=x; -- key line: Is this considered an "update"
>> of t1.x?
>
> Igor pointed to the standards text, which I think is quite reasonable:
> an update is only
On Tue, Sep 22, 2009 at 04:45:31PM -0400, D. Richard Hipp wrote:
> UPDATE t1 SET x=x; -- key line: Is this considered an "update"
> of t1.x?
Igor pointed to the standards text, which I think is quite reasonable:
an update is only an update if something changes.
The same should probably
> Is the only change the absence of a call to "fsync()" when turning
> synchronous off? If so, I can conclusively say that fsync() is very slow
> on this storage device.
Yes, the only action of synchronous = off is to turn off calls to
fsync() which is called at least twice during each commit.
Pa
On a RAID-5 array of 4x SAS disks, turning the sync off made it about 2x
faster, give or take.
On the "SSD", it was about 150x faster.
Is the only change the absence of a call to "fsync()" when turning
synchronous off? If so, I can conclusively say that fsync() is very slow
on this storage de
If you execute
pragma synchronous = off;
you'll be able to compare performance with syncs and without them. So
if you make this comparison on standard spinning disk and on SSD
you'll see if syncs on SSD indeed extra-ordinary slow.
Pavel
On Wed, Sep 23, 2009 at 10:09 AM, Mark wrote:
> It's very
It's very possible, but I don't know how to tell. Is there an easy way
to know if the sync() calls are taking inordinately long?
Mark
Thomas Briggs wrote:
>Is the sync necessary to commit a transaction slow? Performance of
> that sync depends on the OS, file system, hardwar, etc. IIRC, so
mcnamaragio schrieb:
> Hello,
>
> Would anyone be interested in sqlite profiler? If yes what features would
> you expect from it?
>
> Thank you.
>
If you mean, that every sub-query and its execution-time is displayed:
yes, definitely! I would even pay money for it.
Features I would expect:
- e
Hello to all,
Being in a pretty much international company, I have come here to ask a few
things about ETL tools and their different languages.
We have offices in the US, in Europe (Italy, France) and in China. We think
English is fine but our European team and Chinese team especially would l
OK, thanks.
In that case I do that in my application code.
RBS
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Christian Schwarz
Sent: 23 September 2009 14:33
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Sq
> Maybe, what is it?
http://en.wikipedia.org/wiki/Profiling_(computer_programming)
Cheers, Christian
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Maybe, what is it?
RBS
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of mcnamaragio
Sent: 23 September 2009 14:16
To: sqlite-users@sqlite.org
Subject: [sqlite] Sqlite profiler
Hello,
Would anyone be interested in sqlite pro
On Wed, Sep 23, 2009 at 08:27:34AM -0400, Pavel Ivanov scratched on the wall:
> What does ~/.sqliterc do, I wonder? And what "startup information are
> you talking about?
>
> This page http://www.sqlite.org/different.html says specifically:
> "SQLite uses no configuration files".
SQLite, the li
Hello,
Would anyone be interested in sqlite profiler? If yes what features would
you expect from it?
Thank you.
--
View this message in context:
http://www.nabble.com/Sqlite-profiler-tp25531129p25531129.html
Sent from the SQLite mailing list archive at Nabble.com.
___
On Wed, Sep 23, 2009 at 12:22 AM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> ydlu wrote:
>> I am Windows CE software developer, so I am really, really want to learn how
>> you built and test "sqlite3.exe" in Windows CE platform. so I can run a
>> console command line
What does ~/.sqliterc do, I wonder? And what "startup information are
you talking about?
This page http://www.sqlite.org/different.html says specifically:
"SQLite uses no configuration files".
Pavel
On Wed, Sep 23, 2009 at 7:19 AM, Raphael J. Schmid
wrote:
> Hello list,
>
> after some (fruitles
Hello list,
after some (fruitless) googling for where to put SQLite startup
information and browsing around http://www.sqlite.org/docs.html
I finally decided to join the IRC channel and ask there.
It was suggested that it might be a good idea to suggest to this
mailinglist that it might be a goo
28 matches
Mail list logo