On 2/2/09 9:05 AM, "cdg1111us" <cdg111...@yahoo.com> wrote:
> I did see your posts in another email list discussing this after I answered
> your question
> here. Like so many things, there is more than one way to do this however if
> your site gets
> big enough, you're not going to be able to do all your calculations on the fly
> as the page is
> displayed. After your site gets enough traffic, you're going to need to do
> the calculations
> at an off-peak time so that you can use a simple SELECT statement to show the
> results.
> This is one of the main premises of data warehousing. In the solution I gave
> you, you can
> set up the number crunching in a CRON job or something in the middle of the
> night when
> the server isn't busy and this will allow you to serve many more users without
> changing
> your methods.
At this time the traffic is limited to only 7 users and cron jobs (sadly)
are beyond me - it's part of my learning curve - I probably took on too
large a project to learn on but c'est la vie
