sorry for the duplicate message.
just ignore it.
On 2012/03/09, at 10:11, Zheng Li wrote:
>
> what if I have to select all columns every time?
> any difference in performance?
>
> On 2012/02/29, at 4:41, Paul DuBois wrote:
>
>>
>> On Feb 28, 2012, at 9:59 AM, Zheng Li wrote:
>>
>>> for exam
what if I have to select all columns every time?
any difference in performance?
On 2012/02/29, at 4:41, Paul DuBois wrote:
>
> On Feb 28, 2012, at 9:59 AM, Zheng Li wrote:
>
>> for example
>> there are 2 tables to save same data
>> table A has 10 columns: a primary key column and 9 blob column
- Original Message -
> From: "Baron Schwartz"
>
> You may be interested in this:
> http://www.mysqlperformanceblog.com/2009/09/28/how-number-of-columns-affects-performance/
Heeh, very interesting. You guys keep churning out the good stuff :-)
--
Bier met grenadyn
Is als mosterd by den
You may be interested in this:
http://www.mysqlperformanceblog.com/2009/09/28/how-number-of-columns-affects-performance/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
even if I select all columns every time no matter it is Table A or B,
A has better performance?
On 2012/02/29, at 4:41, Paul DuBois wrote:
>
> On Feb 28, 2012, at 9:59 AM, Zheng Li wrote:
>
>> for example
>> there are 2 tables to save same data
>> table A has 10 columns: a primary key column
not to mention, updating any field on table 2 requires the entire
contents to be written out again instead of being able to effect those
columns individually.
Quite a few NoSL solutions work on a similar model which, while useful
in places, is decidedly NOT relational. If you are *certain* that t
On Feb 28, 2012, at 9:59 AM, Zheng Li wrote:
> for example
> there are 2 tables to save same data
> table A has 10 columns: a primary key column and 9 blob column
> table B has 2 columns : a primary key column and 1 blob column which includes
> all data in 2nd~10th columns of table A
>
> are th
