Difference between revisions of "Extension talk:CurrentPages"
From Organic Design wiki
m (→Changing to DB storage) |
m (→Changing to DB storage) |
||
| Line 39: | Line 39: | ||
# Render list | # Render list | ||
| − | + | SELECT page, SUM(views) AS totals FROM $table GROUP BY page ORDER BY totals DESC LIMIT $n | |
| − | SELECT page, SUM(views) AS totals FROM $table | ||
</php>}} | </php>}} | ||
Revision as of 03:18, 25 May 2008
The main functionality is all in the function called by ExtensionSetup. It's not very efficient because the file is read and written for every request and due to the large number of articles read over a 24 hour period, the file can get up to a 1 megabyte or so. The best way would be to create an additional database table to store the entries by. The PayPal extension has example code for adding and using a new table. Another efficiency gain would be to store article ID's rather than text.
