markzz/aurweb.git/web/lib/pkgfuncs.inc, branch 1.5.6.3

Specify explicit joins for package search

2009-06-18T05:47:17Z

Refactor the query to use explicit LEFT JOINs, which appears to be handled by MySQL in a saner fashion than the previous implicit join syntax. This is part two in a slight fixup for observed slow queries in the production environment. With the new indexes and this fixup, a particular iteration of this query will examine only 13346 rows instead of 272060. Signed-off-by: Dan McGee Signed-off-by: Loui Chang

Don't hit the database twice per comment on package

2009-04-13T14:07:46Z

It's performance improvement day today. For non-superusers, we were hitting the database twice per comment on a package- once to get the UID, and once to check the owner of the comment. The best part is we already knew the owner of the comment, and we only need to get our own UID once. For viewing a package like yaourt, this cuts a single pageview from over 700 queries to around 18, which is still not great but a pretty big improvement. Signed-off-by: Dan McGee Signed-off-by: Loui Chang

Fix search output if no results are found.

2009-03-03T18:22:53Z

Signed-off-by: Loui Chang

Go to details page when a search returns one result.

2009-03-03T17:55:14Z

Signed-off-by: Loui Chang

pkgfuncs.inc: Fix indentation.

2009-03-03T17:11:49Z

Signed-off-by: Loui Chang

Update cleanup script to remove non-unsupported files.

2009-03-03T16:21:08Z

Signed-off-by: Loui Chang

Fix the comment poop bug.

2009-02-21T01:59:07Z

Signed-off-by: Loui Chang

Add 'Out of Date' detail in search form

2009-02-18T14:31:20Z

Signed-off-by: Loui Chang

Move package comment form into a new template.

2009-01-25T18:17:54Z

Feature the form on the package details page. Signed-off-by: Loui Chang

Add package details template (pkg_details.php)

2009-01-24T06:22:19Z

Signed-off-by: Loui Chang