(eg. a widget to display newest posts to the forum on main page).
Should I use db_foreach or db_multirow.
Are there any differences in performance between those two?
If you are using postgres you can use the "limit 10" statement to only return 10 rows and in oracle you can use rownum < 10 (rownum is a psuedocolumn in all oracle queries). So the trick is to do the query, sort it, and only return the rows you want to display.