Slow Sort,

[radiodan]

I'm sure this topic must have been covered before, but I wouldn't find anything directly relevant...

I have about 3000 records, that I sort before working on them. They are sorted by Company (in one table) and then Firstname / Surname (in another related table). The Sort is currently taking about 15 seconds the first time and then much quicker. Similarly I have 500 emails held in 1 table that are sorted by date, this takes about 10 seconds to sort.

Compared with the rest of the solution these times are really long, is there anything I could do speed up the sort?

The solution is hosted on FM8 server that serves about 10 users. Am I right in thinking that the sorts are done client side anyway?

Thanks in advance for any help.