> hello,
>
> i m facing a problem with a easy thing.
> i have a table with 10 000 000 rows
>
> Table Property
> Date timestamp;
> LocalisationID Varchar(100);
> Price NUMERIC(15,5);
> Beds SMALLINT
> Baths SMALLINT
> SQFT NUMERIC(12,4)
>
> all columns have an index on it.
>
> to gave you an idea, you can query this database from
> http://www.trulia.com/

is this trulia service actually running on Firebird or is this an example of
what you are trying to do?
Alan