In short what i'm trying to achieve is reduce the number of round trips
from our webservers to our databases, as well as abstract the bulk of
the sql logic to a package in the database. There is a fair bit of
logic and string manipulation involved in achieving this. Also the
table i'm dealing with contains 24million rows, and I'd like to
minimise the amount of knowledge required by the webmaster.... so I
simply create the functions he needs to achieve the results, and he
then uses them in the site. This way the sql statements on the website
a relatively simple and the more complex queries using ranks etc. Also
if any tuning needs to be done it can be performed at the database
level rather than changing queries on the site.
Received on Fri Jan 07 2005 - 05:31:28 CST
