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] ======================================================================= [email protected] (David W Noon) ======================================================================= -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
