Re: Indexing one byte flags - what implementattion is better

2007-12-28 Thread Artem Kuchin
y popular in mysql list! -- Artem -Original Message- From: Artem Kuchin [mailto:[EMAIL PROTECTED] Sent: Thursday, December 27, 2007 1:19 PM To: mysql@lists.mysql.com Subject: Indexing one byte flags - what implementattion is better Maybe someone could provide a good resonable input on th

RE: Indexing one byte flags - what implementattion is better

2007-12-27 Thread Garris, Nicole
me. So for CASE 2 you'll need a third object to keep track of the highest value for id. -Original Message- From: Artem Kuchin [mailto:[EMAIL PROTECTED] Sent: Thursday, December 27, 2007 1:19 PM To: mysql@lists.mysql.com Subject: Indexing one byte flags - what implementattion is better

Indexing one byte flags - what implementattion is better

2007-12-27 Thread Artem Kuchin
Maybe someone could provide a good resonable input on this issue. Let's say i have a table products CASE 1: table: products id int unsigned not null, name char(128) not null, f_new tinyint not null id - is basically the id of a product name - is the name of a product f_new - is a one byte fla