On Thu, Jul 15, 2010 at 10:20:22PM +0200, Florian Weimer wrote:
It's a generic Linux problem, not an ext3-specific issue. Until
recently, the Linux block layer had no concept of a sync operation.
Linux basically assumed that all writes were synchronous and ordered,
which they are not if your
On Fri, Jul 03, 2009 at 03:02:57PM +0800, knightfeng wrote:
We have to do 5,000,000 selects from a database with 4 record
(using C API).
Are you sure you really want/need an SQL database for this?
___
sqlite-users mailing list
On Fri, Mar 06, 2009 at 12:27:32PM -0800, Nuzzi wrote:
I have a project where I have to be determining if a row exists, if
so get the data, change it, and then write it back, if not, then
just writing the data. I have to be able to do millions of these
per minute. Is that pretty much
On Thu, Feb 26, 2009 at 09:53:18AM -0600, Jay A. Kreibich wrote:
I've always wondered about this... someone please correct me if I'm
wrong, but my understanding is that there wasn't any difference
between a left and right join except for the argument order. It
seems like implementing
On Mon, Feb 23, 2009 at 04:28:00PM -0500, D. Richard Hipp wrote:
Remember: SQLite is not trying to replace Oracle. SQLite is trying
to replace fopen().
Exactly. SQLite is *wonderful* for this, and I would hate to see it
compromised by adding features that really aren't necessary.
There are
On Fri, Jan 09, 2009 at 09:18:09AM +0100, Pierre Chatelier wrote:
I have two separate SQLite database files, but containing the same
kind of tables. Is there a quick way to copy rows from one table of
a file to the same table of the other file ?
ATTACH DATABASE 'fromdb.sqlite' AS fromdb;
On Thu, Jan 01, 2009 at 08:19:01PM -0500, D. Richard Hipp wrote:
FWIW, nested transactions (in the form of SAVEPOINTs) will appear in
the next SQLite release, which we hope to get out by mid-January.
Is that going to be 4.0.x then? I'm assuming there will need to be
incompatible file format
On Sun, Dec 28, 2008 at 11:49:34PM -0800, Webb Sprague wrote:
I am sure there is a better way to deal with 12K rows by 2500 columns,
but I can't figure it out
2500 columns sounds like a nightmare to deal with
could you perhaps explain that data layout a little?
On Sun, Dec 14, 2008 at 11:04:56PM -0600, aditya siram wrote:
sqlite create table test_table (Contents varchar);
sqlite insert into test_table hello . world;
SQL error: near hello . world: syntax error
insert into test_table values(hello . world);
On Wed, Sep 17, 2008 at 11:44:38AM +0530, Aravinda babu wrote:
Is there any easy way to get the last row in the table ?
what do you mean by last? last by row id?
then
select * from t1 where oid = (select max(oid) from t1);
should work
___
MySQL:
mysql SELECT a AS b, b AS a FROM t1 ORDER BY a;
+--+--+
| b| a|
+--+--+
|1 |2 |
|9 |8 |
+--+--+
2 rows in set (0.00 sec)
mysql SELECT b AS a, a AS b FROM t1 ORDER BY a;
+--+--+
| a| b|
+--+--+
|2 |1
On Mon, Aug 18, 2008 at 04:38:03PM -0400, Darren Landrum wrote:
Software synthesis applications, particularly disk-streaming
samplers, are very high-performance programs, so I'd like to keep
disk I/O as clear as possible. Every touch of a GUI widget will
result in a query run on the database,
On Thu, Aug 14, 2008 at 10:59:57AM +1200, Chris Brown wrote:
Then this after sqlite3_close but before the second call to system:
.
..
0
1
2
3
5
6
that seems wrong, for those which are symlinks (ie. 0-6) can you also
readlink and print that out too please?
it seems like some fd's are
On Thu, Aug 14, 2008 at 04:37:48PM +1200, Chris Brown wrote:
After SQLite:
[... odd output ...]
pipe:[120]fd1 ?g?T 1?? 2 04:54:50 CST 2008
6
pipe:[120]fd1 ?g?T 1?? 2 04:54:50 CST 2008
[BTW; Your email is encoded in a very odd way and looks quite
strange to me (others might have more
On Wed, Aug 13, 2008 at 05:08:26PM +1200, Chris Brown wrote:
At the moment I can replicate this issue simply by having the code
sample in my previous post inside my main function with the sqlite
database variable declaration and thats it.
before the system calls can you make a fucntion that
On Tue, Jul 29, 2008 at 02:03:01PM -0700, Joanne Pham wrote:
I still have the problem to set the result of the below statement to
variable so I can print out mulitple times without the executing the
select statement over and over again.
create a view?
select '#device local time = ' ||
On Wed, Jul 23, 2008 at 02:11:27PM +0100, Andrew Gatt wrote:
I have a table of music artist names which i'd like to output in
order. Normally i just use:
select * from artists order by artist_name;
What i'd really like to do is order the artists by name but ignore
any the or the,
17 matches
Mail list logo