[AccessD] Performance Listview

E-business2start.com - Marcel Vreuls oost at e-business2start.com
Wed Mar 15 14:50:51 CST 2006


Thanks, i will take a look at it
-----Original message-----
From: MartyConnelly martyconnelly at shaw.ca
Date: Wed, 15 Mar 2006 20:47:16 -0800
To: Access Developers discussion and problem solving
accessd at databaseadvisors.com
Subject: Re: [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. 
> >Ipopulate 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
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


_______________________________________________________________________
E: oost at e-business@start.com
F: +31-84-758-0746

Dit e-mailbericht is uitsluitend bestemd voor de geadresseerde(n). Indien de e-mail bij vergissing bij u terecht is gekomen, wilt u ons dan direct bellen? Wij verzoeken u in dit geval de e-mail te vernietigen, de inhoud ervanniet te gebruiken en niet onder derden te verspreiden, omdat het bericht vertrouwelijke informatie kan bevatten, beschermd door een beroepsgeheim. Wij danken u vriendelijk voor uw medewerking. 





More information about the AccessD mailing list