Thanks, I really appreciate the input I have recieved. You suggestion took care of the descriptor file, but version 4.14.1 did not help. I have taken a much more caveman approach to trying to solve this because programming is not my vocation. I'm simply trying to create a tool that will help us in our office. I removed all of the currencyformatters, I removed all of the itemrenderers, and I removed all of the filters from my program. So essentially, all I had was an arraycollection with my raw data in it displayed in a spark datagrid. And the sorting was still unbelievably slow, 15 to 30 seconds at times with the program completely locking up. I'm using SQLite as the database, so all of my data is either strings, integers, or numbers, so I don't think there is anything highly unusual with my data. It was so much faster when I was using the mx component. Unfortunately, I just found the spark datagrid to display much nicer, to render fonts much more beautifully than the older component, and I enjoyed working with it. But slow as molasses.
Funny thing, there is an old database program deployed in AIR called Lita that I like to use to quickly look at my sqlite database, and it displays my data using the older mx datagrid. Clicking on the headers in Lita sorts the exact same data almost instantaneously. So I have to believe that it is just the difference between the sorting capabilities of the components. Essentially, all I am doing is "SELECT * FROM main" to load from the database, setting the results as the source of my arraycollection, and displaying it in a datagrid. With the filters removed, the currencyformatters removed, and the itemrenders removed, I can't imagine what I could do programatically to make this simple application any faster. So the only question I have left before I give up on the spark datagrid and move back to the mx version is, could writing my own sort routines somehow run faster than what is built into the spark datagrid? Could it possibly eliminate anything that is clogging up the system? Thanks -- View this message in context: http://apache-flex-users.2333346.n4.nabble.com/Why-are-Spark-Datagrid-headers-sorting-my-data-so-slowly-in-Air-tp13026p13046.html Sent from the Apache Flex Users mailing list archive at Nabble.com.
