Russell Keith-Magee skrev: > Ok. In which case, a Sybase backend will probably hit the same > problems as the existing MS SQL backend. MS SQL doesn't contain > support for LIMIT/OFFSET in queries, which Django uses these keywords > to optimize the results obtained from large queries. (I think this > problem has been fixed in SQL Server 2005, but don't quote me on that. > I don't keep close tabs on MS SQL). > Perhaps we (that is, the people who want MS-SQL support) could use the technique described here:
http://josephlindsay.com/archives/2005/05/27/paging-results-in-ms-sql-server/ I do believe there might be a subtle problem in the case where the sort key is not unique - in that case, TOP X can return more than X records, IIRC. We might have to add the primary key to the SORT BY as a last resort when sorting by a non-unique field. Nis --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
