Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
1 Contribution
Ranked #107.41K
Discussions / Questions x 1
~172 People Reached
Favorite Forums
Databases x 1
Favorite Tags
mysql x 1
Member Avatar for JokerOfACoder
Static Count vs Dynamic Count (Very advanced, gurus take your shot)
Share on Facebook Share on Twitter Share on LinkedIn

I'm building a large scale application and was wondering the difference between static counts vs dynamic counts. Right now, I'm using dynamic counts. For an example: [code] SELECT *, (SELECT COUNT(1) FROM CarImages WHERE CarImages.carid = Cars.id) as ImageCount, (SELECT COUNT(1) FROM CarBuyers WHERE CarBuyers.carid = Cars.id) as BuyerCount, (SELECT …

Databases mysql
Member Avatar for cfAllie
0
1
172