We have a small and 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 do this small re-write, make two bug/layout fixes, 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-coder can understand the process, I just can't invest the ramp-up time to learn to code php.
Improve efficiency of code by (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).
-Changing an SQL-heavy dynamic auto-linking function into a do-once-on-change that stores the result in a field
-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 (a small layout change with one new if|else).
Repair a small bug (missing RecordID value at the end of a URL produced as output).
If this goes well, there is a larger re-write and addition of a reputation system as a follow-on contract