Re: kaka's query speed is slow

Hi, Philip, Here is the query as you suggested: SELECT ox.ensembl_id, x.dbprimary_id, x.display_id, db.db_name FROM objectXref ox, Xref x, externalDB db WHERE ox.ensembl_id IN ('7263', '7318', '8991', '17508') AND x.xrefid = ox.xrefid AND db.externalDBId = x.externalDBId; > > Maybe "WHERE ... I

Re: kaka's query speed is slow

? Thanks Wilfred On Thu, 29 Nov 2001, Wilfred Li, Ph.D. wrote: > Hi, Philip, > > Here is the query as you suggested: > > SELECT ox.ensembl_id, x.dbprimary_id, x.display_id, db.db_name > FROM objectXref ox, Xref x, externalDB db > WHERE ox.ensembl_id IN ('7263', '73

dropping auto_increment PK/Index

Hi, Is it possible to drop an auto_increment column index or primary key to boost performance for bulk inserts? It seems mysql requires auto_increment columns to be a key at all times. Here is the error message: Incorrect table definition; There can only be one auto column and it must be define