UBB.Developers Forums UBB.threads 6 V6 Modifications Forum Design Integration IIP SideBarPal 1.1

I forgot to mention, I have about 40,000 users which probably slows this query down:

SELECT U_Username,U_Registered,U_Picture,U_PicWidth,U_PicHeight,U_Number
FROM {$config['tbprefix']}Users
WHERE U_Approved = 'yes'
ORDER BY U_Number DESC LIMIT 0,1