[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Does the Number of Fields in Products Effect Performance
****** message to minivend-users from birgitt <birgitt@hamburg.citde.net> ******
Thompson-Jordan wrote:
> ****** message to minivend-users from "Thompson-Jordan" <Thompson-Jordan@mindspring.com> ******
>
> I'm using GDBM with a 1000-2000 products. My product database has a large
> number of fields (50+). Most of the fields are only displayed on flypage.
> Only the first 8 fields are used my most searches.
>
> - Does having a large number of fields affect search performance?
>
No, I don't think so. Mine had round about the same amount of fields, manyof them only displayed on the
flypage. Record number over half a million.
> - If I mainly the first few fields, is performance the same no matter how
> many additional fields I have?
>
It 's how you search the field, how you index and split, which makes the difference.
Birgitt Funk
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
