1
elpaksu
Module Recette slow search!
  • 2006/9/21 11:07

  • elpaksu

  • Just popping in

  • Posts: 10

  • Since: 2006/2/9 1


Simply search on moduel recette take about 16 sek.


You can test it here


Quote:
SELECT storyid,uid,title,created FROM xoops_test_recette, xoops_test_recette_lnk_ingredient_recette WHERE published>0 AND published<=1158494315 AND ( (hometext LIKE '%dunavski%' OR bodytext LIKE '%dunavski%' OR title LIKE '%dunavski%' OR ( storyid = recette AND ingredient LIKE '%dunavski%' ) )) GROUP BY storyid ORDER BY created DESC LIMIT 0, 5 ( 15.711812)


Who can help me

TnX

Login

Who's Online

499 user(s) are online (434 user(s) are browsing Support Forums)


Members: 0


Guests: 499


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits