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 cannot

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