[AccessD] Performance Listview

You might have a look through Stepan Lebans site, he has about a dozen 
examples of various listbox methods
One is a class that does row colouring. Whether it's faster dunno.
http://www.lebans.com
http://www.lebans.com/listboxenhanced.htm
Other ideas and methods
Combos with Tens of Thousands of Records
http://allenbrowne.com/ser-32.html

E-business2start.com - Marcel Vreuls wrote:

>Hi,
>
>In order to make my A2k more attractive and user friendly i have replaced the standard Listview with the comm.contr. Listview from MS. 
>I populate the listview by selecting a DAO.recordset and than use the  .ADD listitems functions to add the records to the listview. After that i call a function which colors the rows accordnig to a certain value in the subitems.
>It works fine but I notice that this goes very slow particularly the coloring of the rows. When i fill the listview with 500 records the filling takes about 5 seconds but the coloring 30 seconds.
>
>Any tips, ideas how ik can make it faster.
>
>I have a database with about 20.000 orders in it. Customers would like to have a listview which shows ALL orders so they can sort, filter etc. This i can not support performance wise with this solution. The standard listview of access is much and much faster.
>
>
>Thanx, marcel
>  
>
>------------------------------------------------------------------------
>
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.1.375 / Virus Database: 268.2.1/278 - Release Date: 09/03/2006
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada