[Lazarus] Embedded database for Lazarus/Linux

[David W Noon]

On Fri, 18 Jun 2010 18:44:21 -0400, waldo kitty wrote about Re:
[Lazarus] Embedded database for Lazarus/Linux:

> On 6/18/2010 17:07, Graeme Geldenhuys wrote:
> > On 18 June 2010 20:58, Henry Vermaak wrote:
> >>
> >> How did you come to the conclusion that databases == slow?
> >
> > I guess with databases it depends on how well managed the database
> > is, how well the database tables are designed, and how skilled the
> > developer is at writing SQL.
> 
> indexes are another huge factor for having efficient databases... i
> can't count the number of times that i've created an index on a set
> of tables and the efficiency has gone up several magnitudes compared
> to what it used to be...

Reminds me of a database I was designing about 10 years ago on an IBM
mainframe.  One query was taking 18-20 minutes to run.  I added another
index to one of the tables -- it had 3 or 4 already -- and the query
dropped to 12 milliseconds.  That is some speed up!
-- 
Regards,

Dave  [RLU #314465]
=======================================================================
david.w.noon at ntlworld.com (David W Noon)
=======================================================================