Can DBISAM handle multiple indices efficiently, and up to how many indices can
I go before I notice extreme degredation?

Sandy


>Can DBISAM handle multiple indices efficiently, and up to how many indices can
>I go before I notice extreme degredation?
>

1. Yes, but only the first field in a multifield index is used as part of SQL SELECT statements (all fields are used for ordering)

2. Depends on what they are The most I have on any one table is 15. Generally they're pretty good. Full Text Indices are the worst, especially if you have custom processing (eg to filter out html code).

Roy Lambert

Sandy,

<< Can DBISAM handle multiple indices efficiently, and up to how many
indices can I go before I notice extreme degredation? >>

I hate to answer a question with a question, but how many indexes are you
interested in adding to a given table ?

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Sandy,

<< Can DBISAM handle multiple indices efficiently, and up to how many
indices can I go before I notice extreme degredation? >>

I hate to answer a question with a question, but how many indexes are you
interested in adding to a given table ?

--
Tim Young
Elevate Software
www.elevatesoft.com

I want to use 11.

"Sandy Ptalis" <sptalis@optonline.net> wrote in message
news:908D7D56-7872-4502-864C-40960C6A52D1@news.elevatesoft.com...

> I want to use 11.

I have 25 on one table including strings, dates, booleans and one full text.
Works great for me with no problems.

-Johnnie

Sany,

<< I want to use 11. >>

You should be fine with 11.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sandy Ptalis wrote:

> I want to use 11.

No problem at all. In one database, I use up to 26 indexes in one table, and
two or three more have over 20. I don't do any batch inserts with thousands
of records. Anything else is fast as hell.

Ralf