Custom fields schema
mkanat at kerio.com
Fri Jan 28 20:50:06 UTC 2005
On Fri, 2005-01-28 at 11:08 -0700, Kevin Benton wrote:
> From what I can see, the fields as columns performance was *much* better
> than the fields as data performance (myk-result-3.html). This suggests to
> me that this particular implementation is not going to work here. I'm not
> saying that a FAR method can not be developed that will perform within
> expectations, but from the data presented, this particular method doesn't
> look like it will suit my needs.
No query should ever take 50 seconds in reality unless the indexes are
off, or unless it actually has to return an immense amount of data that
must be read from the disk.
I'm pretty sure that we will have to require a Bugzilla with
transactions instead of table locking, though, to get ideal performance
from custom fields in either method (though it could be particularly
applicable to FAD).
Technical Support Manager, USA
Kerio Technologies, Inc.
2350 Mission College Blvd., Suite 400
Santa Clara, CA 95054
Phone: (408) 496-2500
Fax: (408) 496-6902
More information about the developers