Another quick question
Moderator: General Moderators
Another quick question
I recently posted about showing a total count using SUM(*), and i have it included on my page as a tiny script to sum out the total count and amazingly the count was over 13,000 downloads. all of a sudden now the page is loading a bit slower since i added it, is it the script working thats doing that or could it just be my server going slow. and if its the script doing it, is there anyway to speed the process up?
- thomas777neo
- Forum Contributor
- Posts: 214
- Joined: Mon Mar 10, 2003 6:12 am
- Location: Johannesburg,South Africa
Over what period of time were those 13,000 files downloaded? Anyway,
You can also use this select statement:
This should be a little quicker, yet I feel this isn't the primary problem.
I feel it has to do something with the server.
What is the size of the file been downloaded aswell?
You can also use this select statement:
Code: Select all
SELECT count(*) from table_name as totalI feel it has to do something with the server.
What is the size of the file been downloaded aswell?
maybe you could have one field in the database updated the hole time containing the downloads. You figure out how, but now the visitor doesn't have to go through all the fields it just adds +1 with the field counting downloads and +1 in the file which is downloaded
.... i hope that helps ya out!
That way you have one 'general' count and one 'specific' count for every file.
That way you have one 'general' count and one 'specific' count for every file.