> i created a delphi software that takes daily stock data (date,high,
> low, close, vol, stock name, symbol) from text file and stores it in
> Firebird database. I store about 2000 different stocks everyday and use
> the database to plot graph. When i store 30 days of data, the respond
> is ok. But as the days increase, the respond time reduce to very2 slow.
> My CPU usage indicate fbserver have high cpu usage. I think it is
> because the table is not organized/sorted. I only have one table with 7
> fields. My questions:
>
> 1. How to have very fast respond for large database?
> 2. Is my problem because of unorganized data?
> 3. How i make my software respond faster?
>
> By the way, i dont include index and sorting of any kind. I just get
> the data and store it.

Well, some kind of index could be a start. If you have to browse
through an increasingly larger number of papers, can you do it all
in the same amount of time? Guess not, so why should Firebird?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com