![]() ![]() |
Home |
How it works |
Projects archive |
Contact Us Air Compressor Bot |
|
| The Career Path of Freelance Programming Jobs |
Cache Search Results |
![]() |
Bidding Time: |
12/12/2004 21:29 - 20/12/2004 21:29 |
Budget: |
N/A |
Status: |
Closed |
|
|
|
Job Type: |
|
Description: |
Hi, My search engine has a .pl file that saves all the search terms made on the search engine to a database. When a search is made on the search engine eg. hotels it queries the database to find all enteries in the database containing the search terms. for example london hotels hotels new york cheap hotels birmingham ect.... displaying them as alternate search terms next to the search results. example www.pmc-search-services.com/travel/hotels/ As you can see it searches for words before and after the original search term. This takes time and can slow down the search results by several seconds for common words. What I would like is to add a cache to speed up the process. The search results are already cached using a txt folder but my alternate search terms are pulled from the database in real time. All search terms are saved to a database with 1 table. This database is not used for any other purposes. I would like a modification done to the script and another table added to the database to cache the results. The would like a few extra lines of coding added to the .pl file to cache the alternate search results my 'x' amount of days, set manually by me. Be able to retrieve 'x' amount of alternate search terms also set by me. The script pulls the results by popularity which is great. I would just like it to cache the results in the order they are already in. If it finds 500 results containing the search term it is fine to cache all 500 but I need to be able to choose how many to display. I would like the 'x' amount of days to cache feature because I want to show the most popular searches at the top of the list so the cache will need updating from time to time. Conclusion, If there is no cache for a search term query main table, cache the results, return query. If a cache exists that is inside the time period return cache results. If a cache exists that is outside of the time period query main table, update the cache, return results. I know this is pretty straight forward for you guys. Please only post if you can start straight away. This is a very quick job. Thank You Additional Info (Added 12/12/2004 at 21:49 EST)... Sorry No escrows payment guarenteed after successful trial. max This project is the proprietary information of .
Click here to remove this project from OUR database.
|
Operating System: |
Linux |
Database System: |
MySQL |
| <<< back |
|
| Home | Projects archive | RSS | Resources | Links | Contact Us | © 2004-2008 ProjectsList.biz /1.31 |