counting rows
From: <bucaliman_at_gmail.com>
Date: 30 Mar 2006 13:11:40 -0800
Message-ID: <1143753100.408985.38260_at_u72g2000cwu.googlegroups.com>
Consider the tables USERS and PICTURES. When retrieving the number of pictures from a user there are two ways:
Date: 30 Mar 2006 13:11:40 -0800
Message-ID: <1143753100.408985.38260_at_u72g2000cwu.googlegroups.com>
Consider the tables USERS and PICTURES. When retrieving the number of pictures from a user there are two ways:
- I count them from pictures table.
- I pick it directly from a field "numPictures" in table users.
How are you used to do this? Which is better? Thanks Received on Thu Mar 30 2006 - 23:11:40 CEST