markzz/aurweb.git/support, branch 1.5.6.3aurweb working repositoryhttps://git.markzz.net/markzz/aurweb.git/atom/support?h=1.5.6.32009-06-18T05:47:17ZAdd multicolumn indexes on votes and notifications tables2009-06-18T05:47:17ZDan McGeedan@archlinux.org2009-04-11T21:40:57Zurn:sha1:e2b3bd1c37d91a747e8f774bbb91aad3dc466c68
To put a long story short, when we do joins on these tables in our
pkg_search_page() function, we always join on both the user ID and package
ID columns. By creating multicolumn indices, we can always get the exact row
we are looking for in the table.
The benefits of adding a unique index should also speak for themselves, as
we previously did not have this on either of these tables.
This is part one of a two-part series to address the fact that this query
was often showing up in our slow query logs.
Signed-off-by: Dan McGee <dan@archlinux.org>
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Move tupkg scripts to tupkg/scripts.2008-12-11T15:22:15ZLoui Changlouipc.ist@gmail.com2008-12-11T15:14:55Zurn:sha1:186abc852a9f442d94cf7fdf44f394993173ccd1
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Update usage and paths in tupkg run scripts.2008-12-11T15:20:59ZLoui Changlouipc.ist@gmail.com2008-12-11T15:09:21Zurn:sha1:084b11a6f2e1575cd7c84dee194d0ab66e2087a4
In run-tupkgupdate:
Set HOME for correct CVS auth.
Properly filter out unneeded messages from
CVS output, and prune empty directories on update.
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
run-tupkgupdate: Fix CVS output grepping.2008-11-28T00:06:07ZLoui Changlouipc.ist@gmail.com2008-11-28T00:06:07Zurn:sha1:f285da5d5715d2830578aa955a5490f7cfa403ab
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Rework tupkg support scripts. Update paths.2008-11-27T04:03:53ZLoui Changlouipc.ist@gmail.com2008-11-27T04:00:34Zurn:sha1:460a6ccb468cbf5c878132a1fc2a888b51a67440
Grep CVS update output for only useful messages.
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Remove redundant tupkgs.conf.2008-11-24T07:55:49ZLoui Changlouipc.ist@gmail.com2008-11-24T07:55:49Zurn:sha1:90cb026fb85a9166188f397ba2e668ab20e58ed9
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Add version, username and description to daily new package email.2008-06-09T20:25:07ZLoui Changlouipc.ist@gmail.com2008-06-09T16:15:16Zurn:sha1:cceb66476ea0ee98f18d3f3c4a459226736f2736
Add some variables to make it more configurable.
Do some general clean up on the script.
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com>
Remove references to AURMaintainerUID2008-03-27T07:34:35ZCallan Barrettwizzomafizzo@gmail.com2008-03-26T13:52:15Zurn:sha1:04dae8d94f846fe5b82d9261405cbc56a736ded3
This (should) get rid of anything to do with the unused column AURMaintainerUID
in the scripts and schema files
Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com>
Signed-off-by: Simo Leone <simo@archlinux.org>
Generate valid dummy data entries2008-03-23T08:04:17ZLoui Changlouipc.ist@gmail.com2008-02-28T16:51:15Zurn:sha1:e64307d8d278ca5514b6f23aa97d51d3fe655736
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Signed-off-by: Simo Leone <simo@archlinux.org>
Make all references to AUR database consistent2008-03-23T08:04:17ZLoui Changlouipc.ist@gmail.com2008-02-28T16:37:39Zurn:sha1:3577326b2b32bad2765cdacd2959dd4fea48c2f8
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Signed-off-by: Simo Leone <simo@archlinux.org>