Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 7 of 7 total |
DBISAM - Indexing |
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 Team Elevate | 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 |
Tue, Aug 1 2006 8:51 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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. timyoung@elevatesoft.com | 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 Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |