![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 7 of 7 total |
![]() |
Mon, Jul 31 2006 10:16 AM | Permanent Link |
Sandy Ptalis | Can DBISAM handle multiple indices efficiently, and up to how many indices can
I go before I notice extreme degredation? |
Mon, Jul 31 2006 11:37 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 ![]() Roy Lambert |
Tue, Aug 1 2006 8:51 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Tue, Aug 1 2006 12:40 PM | Permanent Link |
Sandy Ptalis | "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. |
Tue, Aug 1 2006 1:38 PM | Permanent Link |
"Johnnie Norsworthy" | "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 |
Wed, Aug 2 2006 2:02 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Sany,
<< I want to use 11. >> You should be fine with 11. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Aug 2 2006 7:02 PM | Permanent Link |
"Ralf Mimoun" | 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 |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |