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 the only condition in WHERE clause. Until MySQL has a way of indexes them, you're stuck. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
