Hi I actually read about that in the Delphi 6 manual ! I have been skimming through it recently to see what did bits I might have missed. When you used the ListView did you do your updates in a beginUpdate ... EndUpdate section? I have found this usually massively increases performance.
Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com ----- Original Message ----- From: "vss" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Monday, October 20, 2003 11:16 AM Subject: [DUG]: Sorting - again > Hi All. > Well after my emails on the weekend, a Listview was not going to cut it > unfortunitly because it took too long to load the data from the DB into > the listview. Even with a dataaware one. > > So I went back to using a DBGrid, and stumbled onto a site that said with > ADO, which I could use, you can use the SORT property to define the wsort > order of the data ! > > i.e. myADOTable.Sort:='Client_ID DESC' or ASC > > This is quite quick, and solved my problems ! > Not sure if anyone else was aware of this, so I thought I would pass it > on. > I was using the TMS DBGrid, but that has some serious issues. Took me > nearly 2 months to get them to fix one problem, and now, if I have found, > if you sort the data, it will do it, but then when you scroll the grid, > the data is no longer sorted and is just a total MESS ! > > Good old DBGrid saved the day ! > > Jeremy > > -------------------------------------------------------------------------- - > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
