Database config for large table

We have a table with a few hundred thousand records with a couple of
dozen columns. Most of the columns are type FLOAT or INT.

 

We have been having a really tough time with performance against this
table. Queries against the table can take several minutes to run, and I
really think that we are just missing something.

 

The table can easily grow to around 100 meg, and I wanted to make sure
there weren't any easy changes we could make to the ".conf" file that
would help us. The database was very peppy when this table had less than
50,000 records, so the performance problems have kind of taken us by
surprise.

 

We run the database in embedded mode and we could give the database
hundreds of meg of memory if we needed to, but I not sure if/how Mckoi
can use the extra memory.

 

I think that I can send a copy of the table if you want to look at it.

 

Thanks.

 

Joel