Re: would number of fields in a table affect search-query time?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: would number of fields in a table affect search-query time?
Дата
Msg-id 200410041906.33483.josh@agliodbs.com
обсуждение исходный текст
Ответ на would number of fields in a table affect search-query time?  (Miles Keaton <mileskeaton@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Miles,

> would the number of fields in a table significantly affect the
> search-query time?

Yes.

In addition to the issues mentioned previously, there is the issue of
criteria; an OR query on 8 fields is going to take longer to filter than an
OR query on 2 fields.

Anyway, I think maybe you should tell us more about your database design.
Often the fastest solution involves a more sophisticated approach toward
querying your tables.

--
Josh Berkus
Aglio Database Solutions
San Francisco

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: would number of fields in a table affect search-query time?
Следующее
От: Patrick Clery
Дата:
Сообщение: Re: Comparing user attributes with bitwise operators