Note to Self

1. Note to Self

   #1

   I have a todo list but isn't very good for saving links. Going to dump a link or two here for further research.
   
   You can safely ignore this.
   
   http://www.sitepoint.com/forums/showthread.php?threadid=69555
   

   From what I understand they made this work better in version 4, although what I would do would be to set it at LIMIT 1000 and grab postids only, then store that in a search table kind of like this:
   
   
   

   CREATE TABLE search(
   
     searchid INT      NOT NULL AUTO_INCREMENT,
   
     userid   INT      NOT NULL,
   
     date     DATETIME NOT NULL
   
   )
   
   
   
   CREATE TABLE search_results(
   
     searchid INT NOT NULL,
   
     postid   INT NOT NULL,
   
   PRIMARY KEY( searchid, postid )
   
   )

   
   That way pagnation is a lot faster since full-text queries can be somewhat expensive and you don't want to repeat the search every pagefull of results.
   

Administrators · All categories · Guildhall