We have a relatively simple lexicon module in our php-based CMS that is written with horribly inefficient SQL usage. The result is that with the large lexicon we wish to implement, the performance is so bad as to make the module unusable.
We are looking for a php coder to make these SQL improvements, make one layout fix, add a few on/off switches for features to the admin interface, and add a "match whole words" option to the search. It is simple enough that I, as a non-php-coder can understand the process, I just can't invest the ramp-up time to learn to code php.
We have already done the work of identifying the locations of the inefficiencies and determining what fixes need to be made - we just need a good php-coder to make the right sytax.
Improve efficiency of code by (alternate recommendations from coder also welcome):
-Moving a half-dozen excessive sql queries' results into variables accessible by all users. Make these queries run only when the DB is changed (and have a manual query run button in the admin interface).
-Change an UPDATE of a counter field to an INSERT in a separate Counting Table
Add on/off switches/function to the admin interface for the display of the various interface elements.
Add a "match whole words" option/function to the search.
Reformat query output (make terms and definitions list side-by-side in columns arranged by language rather than definition written under the term).
If you are interested in the details of the changes to be made, please ping us in the message board and I'll send on the detailed document.
If this goes well, there is a larger re-write and addition of a reputation system as a follow-on contract.
We are expecting to pay $200 or less for this project.
Hi, My name is Igor, I have a large IT deveplopment expirience. Here is my online resume: [url removed, login to view] I can make it fast and comfortable for you. Greetings, Igor Racyborynsky