On 5/13/07, Yves Goergen <[EMAIL PROTECTED]> wrote:
On 12.05.2007 22:57 CE(S)T, Ingo Koch wrote: > Fortunately your guess is wrong. ;-) System.Data.SQLite supports > user defined collation sequences. See TestCases.cs of the source > distribution for samples how to implement them. Ah, now I realised that I'd also like to have that "natural sorting", meaning this:
...
Can this be done with a user-defined collation, too? How does this all impact on the performance? I have over 5.000 rows to sort on 3 columns and would like to do that in near-real-time.
It's up to you to feed with a collation that does natural sort. A few thousand rows are not much in modern computer terms, but I have no idea on the impact in terms of performance the .NET wrapper has. Test it and you'll know. Regards, ~Nuno Lucas ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
