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...
I remember when I started at our company
(which I worked at some years earlier too), the first thing I did was
look where the program was slow. One report took 2-3 minutes to run. I
looked at the code and simply said: WTF! 10 minutes of refactoring
the code (undoing their mess) and rewrote the SQL statements... I got
that initial 2-3 minute report down to 4 seconds.
kinda makes ya go "hummm..." :)
So in summary, using a database doesn't instantly mean faster! Binary
files or Databases - you still need a skilled developer to make it
work.
absolutely!
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
