So I have a bit of a problem,
The application I am working is (atm) very SQL hungry , it is procedural and has no framework per say.
Each page at the moment is created dependant upon a query string and the page 'content' is in actual fact an iframe(Please dont make issues arounf this, the future version is a re-write for full OOP and server efficiency) but this issue will be a future problem too
I want to be able to link a help page (from an outside url) to the current page.
Now I really am looking for efficiency here and this is why I am umming and ahhring
The link can be looked up using a flat file, SQL or hardcoded into each page, the last option is out as it means a lot of extra work, so I am looking to a Flat file look up or a SQL query.
This application has thousands of page hits each day so even a small SQL query will have larger implications later on.
But would a flat file look up be any more efficient because relative to the application the number of help files is around 35, where as the number of pages is dynamic and is built using various methods.
So My question is this, if a server building a page adds the extra data to build the link, would it be more or less efficient than using a flat file look up to index the help file to a particular page.
Please also remember that if a page needs a help file it has to calculate this, so the page table would have the help file flag and the info to build the link. whereas a flat file would be a $key=>$value set up using the query string data to retrieve the link data.
All help appreciated