On Sat, Jan 29, 2011 at 01:03:05PM -0800, Marian Cascaval wrote:
> Here's the info source on LAST() function:
>
> http://www.w3schools.com/sql/sql_func_last.asp
>
>
>
> I needed to retrieve the last row from a table.
If you need the "last row from a table" that's trivial to do efficiently
in S
I think a single process accessing a single Sqlite database at a time over NFS
is supposed to be fine.
But it is not working on Solaris.
On Solaris, man page of mmap() has
EAGAINThe file to be mapped is already locked using
advisory or mandatory record lockin
On 30 Jan 2011, at 2:16am, Jay A. Kreibich wrote:
> You'll see the slow down anytime you access anything "past" the BLOB.
> To avoid that, put the BLOBs at the end of the rows and avoid "SELECT *"
> style queries.
Avoiding 'SELECT *' unless you actually want * is good advice in any case.
Sim
On Sat, Jan 29, 2011 at 03:07:47PM -0800, Rael Bauer scratched on the wall:
> It seemed strange that a simple "select * from table" that I was
> doing was so slow. The table contained about 20 columns (fields)
> and 300 rows. The select took about 1.5 seconds. (using SQLite Expert).
> So my questi
On Saturday, January 29, 2011 at 5:54 PM, Rael Bauer wrote:
> The table contains an id field with a unique index and another field with a
> non-unique index.
>
>
> > So you got about 40 Meg of data in 1.5 seconds. Use your OS's copy command
> > (or some graphical equivalent) to duplicate that
The table contains an id field with a unique index and another field with a
non-unique index.
>So you got about 40 Meg of data in 1.5 seconds. Use your OS's copy command
>(or some graphical equivalent) to duplicate that file. How long does it take
>?
You seemed to miss what I was saying:
I
On 29 Jan 2011, at 11:07pm, Rael Bauer wrote:
> It seemed strange that a simple "select * from table" that I was doing was so
> slow. The table contained about 20 columns (fields) and 300 rows. The select
> took about 1.5 seconds. (using SQLite Expert).
Do you have an indexes or UNIQUE restric
It seemed strange that a simple "select * from table" that I was doing was so
slow. The table contained about 20 columns (fields) and 300 rows. The select
took about 1.5 seconds. (using SQLite Expert).
The table contained a blob field, with a "fair" amount of data spread over the
rows (max was
Thanks for the professional explanation.
I think I begin to see the importance of specificity of database query.
Nevertheless, I found another info source on LAST() function:
http://www.codesnout.com/SQLSample/SQL-LAST.php
They also say "The LAST() function is not supported by certain databases.
On Saturday, January 29, 2011 at 3:06 PM, Marian Cascaval wrote:
> As I see it,from the point of view of just retrieving the last row from a
> table,
> no ORDER BY is necessary thus saving processor time.
No, no, no, no. The db doesn't know what you mean by "last". If it happens to
give y
On Saturday, January 29, 2011 at 3:03 PM, Marian Cascaval wrote:
> Here's the info source on LAST() function:
>
> http://www.w3schools.com/sql/sql_func_last.asp
>
>
>
> I needed to retrieve the last row from a table.
> And the example (the workaround tip) in the above link solved my issue.
>
As I see it,from the point of view of just retrieving the last row from a
table,
no ORDER BY is necessary thus saving processor time.
From: Nicolas Williams
To: General Discussion of SQLite Database
Sent: Sat, January 29, 2011 10:51:30 PM
Subject: Re: [sqli
Here's the info source on LAST() function:
http://www.w3schools.com/sql/sql_func_last.asp
I needed to retrieve the last row from a table.
And the example (the workaround tip) in the above link solved my issue.
From: Puneet Kishor
To: General Discussion of S
On Sat, Jan 29, 2011 at 12:38:37PM -0800, Marian Cascaval wrote:
> Hi!
>
> Is LAST() function going to be supported?
>
> Or will the "SELECT ... FROM ... ORDER BY ... DESC LIMIT 1" workaround always
> be
> enough?
>
> My concern is if there might be any speed improvement if LAST() function wer
On Saturday, January 29, 2011 at 2:38 PM, Marian Cascaval wrote:
> Hi!
>
> Is LAST() function going to be supported?
>
> Or will the "SELECT ... FROM ... ORDER BY ... DESC LIMIT 1" workaround always
> be
> enough?
>
>
>
>
Where did you get information on this "LAST()" function?
> My
Hi!
Is LAST() function going to be supported?
Or will the "SELECT ... FROM ... ORDER BY ... DESC LIMIT 1" workaround always
be
enough?
My concern is if there might be any speed improvement if LAST() function were
to
be implemented, comparing to the workaround.
Marian Cascaval
__
16 matches
Mail list logo