Doc,
When the user clicks on the Category on the left, it is not
changing the URL. If I change the url manually to "Path=2" etc. and
press enter, the page loads correctly with that category. So it looks
like your problem is the PHP code not executing the SQL query at all
or it is not req
On Thu, September 15, 2011 11:27, The Doctor wrote:
> 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
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
>>> column, which allows you to spec
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 wrote:
>
Call me stupid, but IMO this is just plain Bad Design. Maybe your masters
are making you want to deliver this, but it's frankly insane. Go instead
with the Sally Rand Principle: show them just enough to pique their
interest. Given that you've narrowed it down to the WHERE clause, try again.
WHERE
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 wrote:
> Forgive my bluntness, but IMO it is silly to attempt to retrieve a 100,000
>
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.
Dr. Doctor,
What kind of 10 entries? Is it insert,update delete etc.
regards
anandkl
On Wed, Sep 14, 2011 at 6:30 PM, The Doctor wrote:
> Question:
>
> How can you optimise MySQL for 10 entires?
>
> Just running OSCemmerce and it is slow to pull up a who catalogue.
>
> --
> Member - Libe
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
