Please respond to the support list instead of to me directly.

> ok, understand. Lets say i create a table for each stock. So i may
> have upto 2000 tables. i will have a master table that keeps track of
> all available stock tables.Each table is sorted according to date.
> Will this be faster? How many tables does firebird support? can i
> access multiple table at the same time?

An index on "stock" could help.

Is the data related in any way? Would you be needing to query
across "stocks"?

If so, keep it in a single table.

Tables cannot be sorted. But you can create indices to speed up
searching when asking for results.

What kind of queries do you need?

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

> Thank you so much for responding.
>
>
>
> --- In firebird-support@yahoogroups.com, "Martijn Tonies"
> <m.tonies@u...> wrote:
> >
> > > 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?
> >