imstillatwork
IS-IT--Management
Is there any way to improve a QoQ speed?
I am taking an initial MySQL result that contains a wddx string in on field, taking that wddx and making it into a query so we can search, sort, filter on the wddx values as if they are now column names.
the main query is fast (< .02 seconds), building the new query is fast (queryNew()), but querying that new query is slow - like .5 seconds. dreadfully slow.
It is a simple query with up to 4 or 5 ANDs in the where clause, and the records returned is never more than 15... I just don't get why it takes half a second? that's crazy slow because this will be a high traffic site for a high profile architecture design company...
the QoQ are unavoidable because we need that wddx data to be search able and sortable as it is part of our insane custom CMS that I've been working on for months now that I can't wait to show you guys when it's done...
Kevin
I am taking an initial MySQL result that contains a wddx string in on field, taking that wddx and making it into a query so we can search, sort, filter on the wddx values as if they are now column names.
the main query is fast (< .02 seconds), building the new query is fast (queryNew()), but querying that new query is slow - like .5 seconds. dreadfully slow.
It is a simple query with up to 4 or 5 ANDs in the where clause, and the records returned is never more than 15... I just don't get why it takes half a second? that's crazy slow because this will be a high traffic site for a high profile architecture design company...
the QoQ are unavoidable because we need that wddx data to be search able and sortable as it is part of our insane custom CMS that I've been working on for months now that I can't wait to show you guys when it's done...
Kevin