# Archive — hermiene.net

However, I looked at my database queries, and designed them a little more logically. Before, I had one master query per view (by category, by series, single books, special criteria, etc.) and sent along GROUP_CONCAT()s for author names, ids, and roles, and for category names and ids, and then had my home-grown print_book() function work on the strings. Now, I do two separate queries inside the function to fish out author and category information, so that instead of one massive and unwieldy master query, I have three smaller ones. The lesson? Don't be afraid to use several queries.