On Wed, Apr 06, 2005 at 01:02:35PM +0200, [EMAIL PROTECTED] wrote: > I'm forced to keep date up to milisec. The reason is simple: I get at > least a couple of new messages per sec, if all of them are stamped with the > same time, the retrieval order id undefined, i.e. once I get it, let's > say, as the last reference on the first page, other time - as the first one > on the second page. In case You do not keep the cache and always performs > the same query even to get the second page it's getting even worse, i.e. > displaying the messgaes 41-80, may bring the message 41, which You already > displayed on your first page as message 40.
Why can't you have a secondary sort on message id? Then you sort by time and message id will always result in consistent ordering. Cheers, Scott -- ATLASSIAN - http://www.atlassian.com Expert J2EE Software, Services and Support ------------------------------------------------------------- JIRA Docs: http://www.atlassian.com/software/jira/docs/latest --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
