Re: How many indexes is too many?
From: Andrew Howell (ajh_at_work)
Date: 11/29/04
- Next message: Hernán Castelo: "createobjectEX"
- Previous message: Andrew Howell: "Re: SQL, which items have certain refs and don't have certain other refs?"
- In reply to: Michael: "How many indexes is too many?"
- Next in thread: Craig Berntson: "Re: How many indexes is too many?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Nov 2004 13:44:08 -0000
Michael wrote:
> Reading some postings, they mention not to use to many indexes (gets
> buggy). One of our VFP6 tables has 85 fields and ~ 120,000 records
> and growing. We do a variety of queries on many fields. Currently we
> have 8 indexes and would like to add a few more. I was wondering what
> a safe # of indexes is without compromising anything.? Any
> input/experiences is appreciated.
We use FPW2.6, there is a table with 17 indexes, 40 fields, 200000 records
and I have twice seen the following problem in the past 5 years:
http://support.microsoft.com/default.aspx?scid=kb;en-us;125576
As you will see from the article, that particular problem is only a known
issue with FPW2.6a and VFP3 but the only thing I could really put it down to
was "lots of indexes / complex index expressions."
[incidentally, both times I just quit all the workstations with the table
open and then it all started working again.]
Maybe there are other issues related to lots of indexes, I'm not even
certain that was the cause of the problem we experienced but I think you
should be fine to add a bunch more indexes to your table.
-- HTH Andrew Howell
- Next message: Hernán Castelo: "createobjectEX"
- Previous message: Andrew Howell: "Re: SQL, which items have certain refs and don't have certain other refs?"
- In reply to: Michael: "How many indexes is too many?"
- Next in thread: Craig Berntson: "Re: How many indexes is too many?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
