On Wed, Sep 14, 2011 at 09:49:34PM +0530, Ananda Kumar wrote: > So, > You want to have 100,000 buttons for 100,000 entries or just have one filter > column, which allows you to specify any type of "WHERE CONDITION" > > regards > anandkl > > On Wed, Sep 14, 2011 at 7:17 PM, Arthur Fuller <fuller.art...@gmail.com>wrote: > > > Forgive my bluntness, but IMO it is silly to attempt to retrieve a 100,000 > > rows, except for reporting purposes, and in that case, said reports ought to > > run against a replica, not the OLTP instance. > > > > Far better, IMO, is to present (in the UI) an alphabet as buttons, plus a > > textbox for refinements. The alphabet buttons cause the recordSource to > > change to something like "SELECT * FROM Clients WHERE ClientName LIKE 'A*'. > > Click the B button and the RecordSource changes to "SELECT * FROM Clients > > WHERE ClientName LIKE 'B*'. IMO, such an interface gives the user all the > > power she needs, and costs the system as little as possible. > > > > To accomplish this, all you need is a sproc that accepts one parameter, > > that being the letter corresponding to the letter-button the user pressed. > > > > I have implemented exactly this solution on a table with only half the > > number of rows you cite, but it works beautifully and it is quick as > > lightning. > > > > HTH, > > Arthur
Arthur, this is exactly what comes to mind. I am wonder what needs to be adjusted in osCommerce for this to work. > > > > > > On Wed, Sep 14, 2011 at 9:24 AM, Ananda Kumar <anan...@gmail.com> wrote: > > > >> Dr. Doctor, > >> What kind of 100000 entries? Is it insert,update delete etc. > >> > >> regards > >> anandkl > >> > >> On Wed, Sep 14, 2011 at 6:30 PM, The Doctor <doc...@doctor.nl2k.ab.ca > >> >wrote: > >> > >> > Question: > >> > > >> > How can you optimise MySQL for 100000 entires? > >> > > >> > Just running OSCemmerce and it is slow to pull up a who catalogue. > >> > > >> > -- > >> > Member - Liberal International This is doc...@nl2k.ab.ca Ici > >> > doc...@nl2k.ab.ca > >> > God, Queen and country! Never Satan President Republic! Beware > >> AntiChrist > >> > rising! > >> > https://www.fullyfollow.me/rootnl2k > >> > Ontario, Nfld, and Manitoba boot the extremists out and vote Liberal! > >> > > >> > -- > >> > MySQL General Mailing List > >> > For list archives: http://lists.mysql.com/mysql > >> > To unsubscribe: http://lists.mysql.com/mysql?unsub=anan...@gmail.com > >> > > >> > > >> > > > > -- Member - Liberal International This is doc...@nl2k.ab.ca Ici doc...@nl2k.ab.ca God, Queen and country! Never Satan President Republic! Beware AntiChrist rising! https://www.fullyfollow.me/rootnl2k Ontario, Nfld, and Manitoba boot the extremists out and vote Liberal! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org