XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / Module Recette slow search!
Register
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

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

149 user(s) are online (69 user(s) are browsing Support Forums)

Members: 0

Guests: 149

more...

Donat-O-Meter

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

Latest GitHub Commits