Sign in to follow this  
Followers 0
Vampie

delete very large ListView

5 posts in this topic

#1 ·  Posted (edited)

Hi all,

I'm using a list view and sometimes there can be like 20.000 lines in the listview.

I read files and add them to the listview

Is there a way to delete all the records in 1 go?

I've tried to use _GUICtrlListView_DeleteAllItems, but that deletes record by record, so it takes a long time to delete them all. ;)

Any ideas?

thank you very much.

Edited by Vampie

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

When you look at the include file you can see that the function handles the delete in two ways depending if you pass a ControlID or a handle to the function.

_GUICtrlListView_Create returns a handle whereas GUICtrlCreateListView returns a ControlId.

So creating the listview with _GUICtrlListView_Create should make the deletion run faster.

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

Welcome to the forum !Posted Image

may be delete the ctrl and re-create is more fast ?

GUICtrlDelete ( $_ListView )

Edited by wakillon

AutoIt 3.3.14.2 X86 - SciTE 3.6.0WIN 8.1 X64 - Other Example Scripts

Share this post


Link to post
Share on other sites

Vampie,

I've tried to use _GUICtrlListView_DeleteAllItems, but that deletes record by record

It most certainly does not - it deletes all records at once whenever I use it (which is quite often!). ;)

But as water pointed out, you need to use the handle, not the ControlID. So if you have created your ListView with GUICtrlCreateListView you need to use:

_GUICtrlListView_DeleteAllItems(GUICtrlGetHandle($hList_View))

wakillon's tip is also a good one - why not try it?

M23


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites

Thank you all.

I've choosen the last solution and it works like a charm.

tnx a lot.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0