Re: increasing InnoDB search performance

2002-02-05 Thread Heikki Tuuri
Eric, "Eric Mayers" wrote in message ... >I have an application that stores a large (up to 6gb) database in an >InnoDB table. I'm using an InnoDB table to have concurrent inserts and >selects and to get beyond the 2gb limitation. > >I have to allow read-only remote database connections and canno

increasing InnoDB search performance

2002-02-04 Thread Eric Mayers
I have an application that stores a large (up to 6gb) database in an InnoDB table. I'm using an InnoDB table to have concurrent inserts and selects and to get beyond the 2gb limitation. I have to allow read-only remote database connections and cannot enforce that users use any kind of special qu