The stock are not related between one and another. I will not do a
query across all stock. One stock tells one story while another stock
tells another story. the only query i will need is to get all of the
data (open,high,low,close,volume,date) of only one particular stock
at any one time.

By the way, how many tables does firebird support?






--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
> 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?
> > >
>