Re: optimising for 100000 entries

2011-09-15 Thread The Doctor
On Thu, Sep 15, 2011 at 08:55:16AM -0400, Shawn Green (MySQL) wrote: > On 9/14/2011 15:26, The Doctor wrote: >> 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 >

Re: optimising for 100000 entries

2011-09-14 Thread The Doctor
> 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 wrote: > > > >> Dr. Doctor, > >> What kind of 10 entries? Is it ins

optimising for 100000 entries

2011-09-14 Thread The Doctor
Question: How can you optimise MySQL for 10 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! ht

REstricting MySQL access to port 3306

2009-09-23 Thread The Doctor
Some months a back I had to firewall port 3306 due to DDoS. I cannot do this now as a client needs 3306 outside the LAN. What can I do to prevent DDoS on my MySQL server? -- Member - Liberal International This is doc...@nl2k.ab.ca Ici doc...@nl2k.ab.ca God, Queen and country! Beware Anti-Chris

Re: PHP MYSQL Admin question

2009-07-23 Thread The Doctor
On Thu, Jul 23, 2009 at 08:47:41AM -0500, Johnny Withers wrote: > Are you sure MySQL is running? > Can you connect with any other MySQL client? > Turns out the php.ini was not set properly. > On Wed, Jul 22, 2009 at 1:55 PM, Dave Shariff Yadallee - System > Administrator a.k.a. The Root of the P