Database to DataGrid to Display FAST!
Posted: Fri Feb 21, 2014 6:14 am
I am trying to grab a group of data from a local sqlite database and insert that data into a datagrid directly. The main objective here is speed. I'm willing to limit my calls to 50, if not 25 rows at a time. However, I'm also displaying thumbnails in this datagrid as well. I found a way to get this done by using this lesson:
http://lessons.runrev.com/s/lessons/m/d ... ts-of-data
However, I just realized that there's no way to get the data associated with each row from doing this. Atleast that's as far as I can understand about this method. The thumbnails are quite small, relatively 25kb per. But with cached controls turned on (for smooth scrolling), I cannot manage to get this data into my datagrid in under a second. If I turn of cache controls, 50 records takes less than half a second even with the thumbnails. However, once this data goes into the datagrid, I also need to be able to get the data associated within each row at any time. As with this lesson, I am not able to do so.
What I'm needing is a way to grab data from a sqlite local database, put that data into a datagrid with thumbnails (the thumbnails are not binary, they are urls but not being inserted as urls, "set filename of image to *http: link goes here*") all in under 2 seconds. It doesn't seem like a complex thing to do but I'm at the point of just going in circles now. Any feedback would be greatly appreciated. Thanks!
http://lessons.runrev.com/s/lessons/m/d ... ts-of-data
However, I just realized that there's no way to get the data associated with each row from doing this. Atleast that's as far as I can understand about this method. The thumbnails are quite small, relatively 25kb per. But with cached controls turned on (for smooth scrolling), I cannot manage to get this data into my datagrid in under a second. If I turn of cache controls, 50 records takes less than half a second even with the thumbnails. However, once this data goes into the datagrid, I also need to be able to get the data associated within each row at any time. As with this lesson, I am not able to do so.
What I'm needing is a way to grab data from a sqlite local database, put that data into a datagrid with thumbnails (the thumbnails are not binary, they are urls but not being inserted as urls, "set filename of image to *http: link goes here*") all in under 2 seconds. It doesn't seem like a complex thing to do but I'm at the point of just going in circles now. Any feedback would be greatly appreciated. Thanks!