Re: [GENERAL] Performance Question - Table Row Size

2007-07-12 Thread Douglas McNaught
Mike <[EMAIL PROTECTED]> writes: > I see. Thank you for the elaborate response. I have a clearer idea of > what is going on now. In designing my application I was thinking of > storing pieces of my data as serialized python data structures into a > binary field (no more than 15KB), while a friend

Re: [GENERAL] Performance Question - Table Row Size

2007-07-12 Thread Mike
I see. Thank you for the elaborate response. I have a clearer idea of what is going on now. In designing my application I was thinking of storing pieces of my data as serialized python data structures into a binary field (no more than 15KB), while a friend was arguing I should store the data in oth

Re: [GENERAL] Performance Question - Table Row Size

2007-07-09 Thread Gregory Stark
"Mike" <[EMAIL PROTECTED]> writes: > I am designing my database and I was wondering whether my table row > size effects the performance of querying my table. yes If your table is large and you're reading all the rows then you'll be limited by the i/o rate. If your rows are twice as big it will

Re: [GENERAL] Performance Question - Table Row Size

2007-07-09 Thread Alexander Staubo
On 7/9/07, Mike <[EMAIL PROTECTED]> wrote: I am designing my database and I was wondering whether my table row size effects the performance of querying my table. Please note that my table is being designed to hold high volume of records and I do not plan to do (select *) for retrieving them. That

[GENERAL] Performance Question - Table Row Size

2007-07-09 Thread Mike
Hi, I am designing my database and I was wondering whether my table row size effects the performance of querying my table. Please note that my table is being designed to hold high volume of records and I do not plan to do (select *) for retrieving them. That is I plan to only query a few of those