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
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
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