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

> Hi,
>
> > I have a table called history with the below attributes:
> > IPAddress int ,
> > RowId int ,
> > DateTime timestamp ,
> > RawSec int ,
> > RawUSec int ,
> > SeqSec int ,
> > SeqUSec int ,
> > CurrValue float ,
> > PresentState smallint ,
> > DataQuality int ,
> > FlagManuallySet char(1) not null,
> > FlagBlocked char(1) not null,
> > FlagControlInhibit char(1) not null,
> > FlagTelemFailed char(1) not null,
> > FlagTestMode char(1) not null,
> > FlagCalcFailure char(1) not null,
> > FlagLinkFail char(1) not null,
> > FlagPointFault char(1) not null,
> > FlagUnreasonable char(1) not null
> >
> > Currently this table has about 22 million of records. The index

has

> > been created on IPAddress, Rowid and DateTime. When I select from
> > this table, I encountered performance problem (as user complained
> > about it). I have no idea how to improve the performance. Can

anyone

> > help ?
>
> I bet a "select * from yourtable" is very fast. So I don't see the

problem?

>
> If there _is_ a problem - you should start describing it before we

can help

> you.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird & MS

SQL Server.

> Upscene Productions
> http://www.upscene.com

Can you advise me what are the information you need ?

I always select with condition such as "where IPAddress = 123 and
RowId = 345 and DateTime >= '2003-10-1 00:00:00' and DateTime < '2003-
10-2 00:00:00'". and I create index key on IPAddress, RowId and
DateTime.

Is the above information help ?

rgds