Re: [GENERAL] one more performance question I cannot test yet :(

2007-04-16 Thread Alvaro Herrera
Sergei Shelukhin escribió: > On Apr 15, 12:13 am, "Sergei Shelukhin" <[EMAIL PROTECTED]> wrote: > > 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 fo

Re: [GENERAL] one more performance question I cannot test yet :(

2007-04-16 Thread Sergei Shelukhin
On Apr 15, 12:13 am, "Sergei Shelukhin" <[EMAIL PROTECTED]> wrote: > 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 se

[GENERAL] one more performance question I cannot test yet :(

2007-04-16 Thread 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