FYI, especially if you are hosting under a shared-hosting arrangement, the total memory available to your program might be extremely small.   Using fetchall_... to fill a popup menu is likely to always be okay (unless your site becomes extremely popular...), but in the general case it is wise to code at all times as though memory were at an extreme premium.