I'm developing a database which contains aprox. 3500 records and each record contains the following fields:
ID - int
Artist, Song, Path - CString
I sort database by reopening it with SQL statement like one that follows:
SELECT * FROM Table1 ORDER BY Artist
The problem is - speed! It takes aprox. 20 seconds to complete this job. Could it be (a little) faster?