From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
> Sets result in table scans if they're the only condition in WHERE
> clause. Until MySQL has a way of indexes them, you're stuck.
Thanx Jeremy!
We've just found another reason (specifics about the data we wanted to store
in the sets have just been rele
On Tue, Aug 10, 2004 at 11:40:28AM +0200, Jigal van Hemert wrote:
>
> How efficient is InnoDB with searching in such sets? Will it use an index or
> must it perform a full table search?
> Are there alternatives which are more efficient regarding search speed?
Sets result in table scans if they're
Hi list,
We're building a relatively large database with InnoDB tables. The database
model is basically: store the data in a table based on the data type. So we
have a param_int table for all integer type data:
CREATE TABLE `param_int` (
`id` int(11) NOT NULL default '0',
`name` varchar(32) NO
