On 11/13/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> 4) Am I doing the right thing? Of course I think the uSQLiteServer is
> the best thing since sliced bread, but then it was designed to meet my
> criteria :-)
I think it is an excellent project. Maybe my problem is similar:
I would like
On 5/13/05, Brandon, Nicholas <[EMAIL PROTECTED]> wrote:
>
> I think I might be getting confused on this subject as well. Does this mean
> that SQLite 3.x can NOT process multiple inserts/updates within one
> transaction if it is working on the same table?
No, that seems to work fine. I guess
On 4/14/05, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> EXPLAIN is your friend. As can be seen by EXPLAINing each query (see below),
> there are fewer instructions involved in the one with the subquery, and no
> sorts or loops as are done in the initial method.
Well, not everybody is a
On 4/14/05, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> How about these:
>
> SELECT * from Mactor WHERE id = (SELECT MAX(id) FROM Mactor);
> SELECT * from Mactor WHERE id = (SELECT MIN(id) FROM Mactor);
I am working on a similar problem at the moment, but unless I missed
something, ORDER
On Apr 11, 2005 4:06 PM, Christian Smith <[EMAIL PROTECTED]> wrote:
> The test given is clearly CPU bound. All the big numbers are from people
> with big CPUs, with equally big RAM performance as well, probably.
I have done a few database test recently, and I often found them to be
CPU bound, at
On Apr 11, 2005 4:17 PM, Christian Smith <[EMAIL PROTECTED]> wrote:
> On Mon, 11 Apr 2005, Thomas Steffen wrote:
> >Is it possible to delay the fsync(), so that it
> >only occurs after 10 or 100 transactions?
>
> No.
Thought so, because the transaction log seems to h
I have a problem where I need both a high throughput (10%
write/delete, 90% read) and durability. My transactions are really
simple, usually just a single write, delete or read, but it is
essential that I know when a transaction is commited to disk, so that
it would be durable after a crash.
I
7 matches
Mail list logo