On Fri, 21 May 2004, LRMK wrote: > I dont like to remove the RANK field onless there is no other solution > becouse this Rating system going to be used by a community of people to > messure the performance of their web sites compaired to others the RANK must > be there. > > I am thinking about calculating RANK once a more longer interval like once > a 7 days. > > > This method of updating will be bit faster if there is a way i can write > this as a function in the DBMS "Like a PL/SQL Function in Oracle" is this > possible in MySQL >
You can use CREATE FUNCTION. But these functions are created in C (i guess), and are compiled in a dynamic library (.so) into mysql. --- Dani Pardo, [EMAIL PROTECTED] Enplater S.A -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>