ChangeSet ID: 26358
CVSROOT: /opt/cvs-commit
Module name: appdb
Changes by: wineowner(a)winehq.org 2006/07/08 19:48:33
Modified files:
admin : adminAppQueue.php
include : application.php comment.php screenshot.php
version.php
Log message:
Chris Morgan <cmorgan(a)alum.wpi.edu>
Performance improvements to version and application classes. Reduce the amount of queries to
what is necessary during object creation. The only use of all but one of the arrays we were fetching
during version and application construction was in ::delete() so we can just retrieve them there.
Speed screenshot class up by only querying for necessary columns, not select *
Patch: http://cvs.winehq.org/patch.py?id=26358
Old revision New revision Changes Path
1.66 1.67 +1 -1 appdb/admin/adminAppQueue.php
1.63 1.64 +18 -20 appdb/include/application.php
1.26 1.27 +10 -0 appdb/include/comment.php
1.43 1.44 +4 -3 appdb/include/screenshot.php
1.71 1.72 +115 -114 appdb/include/version.php
ChangeSet ID: 26357
CVSROOT: /opt/cvs-commit
Module name: appdb
Changes by: wineowner(a)winehq.org 2006/07/08 19:39:43
Modified files:
. : appimage.php
Log message:
Chris Morgan <cmorgan(a)alum.wpi.edu>
appimage should use the image sUrl instead of the iId when trying to stat() the file. We can't always be sure
that the iId will be the name of the file
Patch: http://cvs.winehq.org/patch.py?id=26357
Old revision New revision Changes Path
1.25 1.26 +4 -3 appdb/appimage.php
Index: appdb/appimage.php
diff -u -p appdb/appimage.php:1.25 appdb/appimage.php:1.26
--- appdb/appimage.php:1.25 9 Jul 2006 0:39:43 -0000
+++ appdb/appimage.php 9 Jul 2006 0:39:43 -0000
@@ -73,12 +73,13 @@ if ($aClean['sREQUEST_METHOD']='HEAD')
header("Expires: ");
header("Last-Modified: ".fHttpDate($iModTime));
}
+
$oScreenshot = new Screenshot($aClean['iId']);
-/* at this point, we know that .../screenshots/$id and
- * .../screenshots/thumbnails/$id both exist as normally
+/* at this point, we know that .../screenshots/$oScreenshot->sUrl and
+ * .../screenshots/thumbnails/$oScreenshot->sUrl both exist as normally
* they would both be created at the same time. */
-$fstat_val = stat(appdb_fullpath("data/screenshots/".$aClean['iId']));
+$fstat_val = stat(appdb_fullpath("data/screenshots/".$oScreenshot->sUrl));
$iModTime = $fstat_val['mtime'];
header("Cache-Control: public");
ChangeSet ID: 26353
CVSROOT: /opt/cvs-commit
Module name: appdb
Changes by: wineowner(a)winehq.org 2006/07/08 17:09:14
Modified files:
admin : adminCommentView.php
include : comment.php version.php
Log message:
Chris Morgan <cmorgan(a)alum.wpi.edu>
Move function in include/comment.php inside of the comment class. This lets us refer to
these functions like Comment:: making it clear they are static functions of the comment class
Patch: http://cvs.winehq.org/patch.py?id=26353
Old revision New revision Changes Path
1.14 1.15 +1 -1 appdb/admin/adminCommentView.php
1.25 1.26 +211 -217 appdb/include/comment.php
1.69 1.70 +1 -1 appdb/include/version.php