- Jun 25, 2009
-
-
louipc louipc authored
I forgot to bump the version again! Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
- Jun 18, 2009
-
-
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
Version using package functions Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
comments need to be removed before concatenating lines, otherwise not matched brackets can cause problems on submit Signed-off-by: Gergely Imreh <imrehg@gmail.com> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
Signed-off-by: Sergej Pupykin <sergej.pupykin@lx-ltd.ru> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
Signed-off-by: Sergej Pupykin <sergej.pupykin@lx-ltd.ru> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
Signed-off-by: Sergej Pupykin <sergej.pupykin@lx-ltd.ru> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
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 <dan@archlinux.org> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
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>
-
- Apr 13, 2009
-
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
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 <dan@archlinux.org> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
louipc louipc authored
Update AUTHORS, and config.inc.proto Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
Signed-off-by: Supern Lee <supern.lee@gmail.com> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
Signed-off-by: Supern Lee <supern.lee@gmail.com> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
- Apr 06, 2009
-
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
- Apr 01, 2009
-
-
louipc louipc authored
Better detection of the build function. Better detection of variables. Support for variables with underscores. Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
- Mar 12, 2009
-
-
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
- Mar 04, 2009
-
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
- Mar 03, 2009
-
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
louipc louipc authored
This closes FS#13017 Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
- Mar 02, 2009
-
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
- Feb 21, 2009
-
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
- Feb 20, 2009
-
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
- Feb 19, 2009
-
-
louipc louipc authored
Make post date consistent with other dates. Look Ma, no tables! Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
- Feb 18, 2009
-
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
louipc louipc authored
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
- Feb 16, 2009
-
-
This only neutralises bash parameter substitution, but doesn't perform the proper replacement. Closes FS#13122. Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-
- Feb 15, 2009
-
-
Lines such as foo=$foo in the PKGBUILD would end up in a infinite replacement cycle when uploaded, thus the upload times out. In these kind of lines, $foo is replaced not by "$foo" again, but deleted (missing value for foo). Signed-off-by: Loui Chang <louipc.ist@gmail.com>
-