Francesc Ortiz wrote:

Hi,

I just subscribed to the AUR mailing list. I developed tupac, a script that does fast aur searches. I got really glad when i found that there is an RPC for AUR, but all my happiness vanished when i saw that the search results show no information, and that i have to add another query for each result if i want to show aditional information to the search results. From my house, this adds a 550 ms query to each result. I gave a try to arson to proove it.

Adding the possibility of specifying the fields you want to show in the search results would reduce rpc query time and would also reduce server load. Getting custom fields would be 1 connection vs N+1 (N=number results, 1 the search) connections that you have to do now for a pacman-like search. And in what time regards, as an example, for 30 results now I need (30+1)*550ms = around 17 seconds.

I also see that this would be more intense work for the database, so it would be reasonable to add a result limit to the search, if you use custom fields, in order to reduce subqueries.

And, about usability, imagine that http://aur.archlinux.org/packages.php took 13 seconds to load.

What do you think, did I sound convincing enough? :P

Welcome. You probably want to try the aur-dev mailing list for this as that is where the people who develop the AUR hang out. Your idea sounds reasonable but I have no idea if it is implementable. Of course, if you know how those sort of things work, you can alway help out improving the AUR! Cheers, Allan