Re: dbus and GNOME 2.8

[Sriram Ramkrishna <sri aracnet com>]

On Tue, Apr 06, 2004 at 07:16:27PM +0100, jamie wrote:
> On Tue, 2004-04-06 at 19:11, Sriram Ramkrishna wrote:
> > On Tue, Apr 06, 2004 at 07:08:59PM +0100, jamie wrote:
> > > > does it all much much faster with much less resource overhead than any
> > > > "big" RDBMS I know of, embedded or not.
> > > 
> > > Faster? Using variants for types I doubt that very much. It might
> > > outperform Postgres but I would be very surprised if it beat firebird.
> > 
> > sqllite is typeless.  Everything is text from what I remember.  So
> > the type system is very simple.  
> 
> Yes but not efficient. (Typeless = variants).
> 
> EG in Firebird, I would *Always* define a table with a primary key that
> was of type integer. Why? because integers are the quickest to sort.
> SQLite allows you to enter a string into such a field so how cant it be
> efficient?

http://www.hwaci.com/sw/sqlite/datatypes.html

The integer primary key is the exception to the rule.

sri