Обсуждение: one more performance question I cannot test yet :(

Поиск
Список
Период
Сортировка

one more performance question I cannot test yet :(

От
"Sergei Shelukhin"
Дата:
Suppose there's a table with two text fields and a lot of int fields.
THe table will be huge, updated constantly, and will be searched by
all of the int fields, whereas text fields will be for display only.

Does it make sense to split it vertically into two tables, one with
ints and one with texts, and join them in queries to make it faster?