Login or create new account.

By registering on joomprod.com, you will have immediate access to all our free products and to the public side of our support forum.

Enjoy our subscriptions.

Each of our subscriptions allow you to enjoy the private side of the support forum and all the update of our products for a period ranging from 3 months to 1 year.

Payment And immediate download.

After subscribing to one of our subscription, the products are immediately downloadable.

Accueil / forum / Support / AdsManager Support / MySQL Problem!!!

Support Availability Because we must sleep sometimes

Working days: Monday to Friday.
Reply time: Depending on the complexity of your support issue it's usually between a few hours to 48 hours.

Support is only guaranteed to paid subscribers

AdsManager - End of life

It is with great regrets that we have chosen to end the developpement of Adsmanager and its other associated components.

AdsManager is born 10 years ago and, as of today, the number of new subscriptions and downloads have fallen and we cannot maintain the component anymore.

All active subscribers will be able to continue enjoying support until the end of their subscription.

The components will be free and no support will be provided anymore for the other users.

Notice

The forum is in read only mode.

MySQL Problem!!!

Start
Prev
1
Next
End

thebasix
Topic Author
Offline
Gold

8 years 1 month ago - 8 years 1 month ago #24316 by thebasix

MySQL Problem!!! was created by thebasix

When I click on "Search" button on simple search module I get results page. Here are 2 mysql that get executed and that are badly written.

First one takes 400ms to execute
pastebin.com/kn5rM9dr

Second one takes 936ms to execute
pastebin.com/PEDWBNMQ

Now this is your problem because you wrote the queries so please FIX this. It affects me.

For your info, I have more 100k ads.

prnt.sc/egrgfn

Last edit: 8 years 1 month ago by thebasix.

thebasix
Topic Author
Offline
Gold

8 years 1 month ago #24387 by thebasix

Replied by thebasix on topic MySQL Problem!!!

When do you plan to fix your fuck up?

juloaadmin
Offline
Gold

8 years 1 month ago #24405 by juloaadmin

Replied by juloaadmin on topic MySQL Problem!!!

Please moderate your language (last I said in previous message).

Yes I think some SQL can be improved here. We are working on some of them for future versions.

There is no BUG it's optimization. (nothing to fix to improve)
All this SQL modification needs time for validation, so we don't have a date for the version that will contains this improvment.

Please note that we are not your personnal developer, I mean you purchase a software for the cost of a couple of hours not for a personnal support 24/24H.
Support is for installation, bug fix, ....
Upgrade for new version that can contains code improvment.

If you can wait the next version of this improvment you can contact us for a quote for a "optimization task" as an extra work.

Start
Prev
1
Next
End

Time to create page: 0.137 seconds