Re: Question on select count()
Date: 17 Aug 2004 09:20:32 -0700
Message-ID: <b399d6ce.0408170627.12849129_at_posting.google.com>
afilonov_at_yahoo.com (Alex Filonov) wrote in message news:<336da121.0408161150.2c0d78d9_at_posting.google.com>...
>
>
> If you are trying to restrict number of rows to <= 50, there is something
> wrong with database design. It'll help if you post what you are trying
> to achieve (in simple words)...
Are you saying I was unclear ? :)
I keep track of sessions in a database. Exceeding a fixed number of sessions should not be allowed.
The reason I do not keep the cound in the Java application was that I wanted to keep the application stateless, to allow for simple load balancing. I thought the database could help me, but at the same time, I think helping me, the database would sacrifice a lot of performance. Received on Tue Aug 17 2004 - 18:20:32 CEST