Search found 54 matches

by engee30
24 Apr 2020, 08:03
Forum: Programming
Topic: Search function - lightning fast
Replies: 4
Views: 11551

Re: Search function - lightning fast

Thanks again, Tiku. As I said earlier, with regards to the CopyMemory function, I couldn't find any solution that would suffice in my situation. And your answer says it all - it's not supposed to be used for that particular scenario. I do remember reading something about the VB6 Collection class, so...
by engee30
23 Apr 2020, 22:10
Forum: Programming
Topic: Search function - lightning fast
Replies: 4
Views: 11551

Re: Search function - lightning fast

Hello Tiku Thanks for your suggestion. And yes, it did the trick to some extent. Do you happen to know of any function that would involve CopyMemory? I've heard the function can deal with lots of data with a great performance rating, but never found any dealing with lotto-like searching functionalit...
by engee30
16 Apr 2020, 18:10
Forum: Programming
Topic: Search function - lightning fast
Replies: 4
Views: 11551

Search function - lightning fast

Hello Tiku You could be away and not using the forum as often as you used to, but anyway I wanted to ask a question of you. I'm working on a lotto project, and I've been trying to find a lightning fast search function, so I could look up in minutes matching numbers and combinations of numbers. I've ...
by engee30
17 Oct 2013, 21:54
Forum: ExplorerListView
Topic: VirtualMode & MySQL
Replies: 19
Views: 19264

Re: VirtualMode & MySQL

This is it. Another perfect solution did the trick. Cheers, TiKu.
Hopefully, there will be no complex issues with my project. :P

Kind regards,
Pete
by engee30
17 Oct 2013, 18:22
Forum: ExplorerListView
Topic: VirtualMode & MySQL
Replies: 19
Views: 19264

Re: VirtualMode & MySQL

Oh that'd be great. I wouldn't have a clue how to do that. :(
by engee30
17 Oct 2013, 11:03
Forum: ExplorerListView
Topic: VirtualMode & MySQL
Replies: 19
Views: 19264

Re: VirtualMode & MySQL

It's me again. :D
Is it true that while working in VirtualMode, there's no Unicode support? I've got some other stuff in the db which doesn't show properly. I just tried the same stuff in the normal mode and it's fine there.

Regards,
Pete
by engee30
16 Oct 2013, 23:33
Forum: ExplorerListView
Topic: VirtualMode & MySQL
Replies: 19
Views: 19264

Re: VirtualMode & MySQL

Thanks TiKu. I really appreciate your help. This is right what I'll stick with. I couldn't think of any better idea by myself. Yours is, roughly speaking, like the one I meant in my previous post, where I wrote: I wouldn't like to end up using the same routine as it is used at the very startup of th...
by engee30
16 Oct 2013, 21:37
Forum: ExplorerListView
Topic: VirtualMode & MySQL
Replies: 19
Views: 19264

Re: VirtualMode & MySQL

I'm afraid there's no way I could handle the issue. Dealing with databases, and only recently with the cache, is quite beyond me. It's not as straighforward as it is with the code I have under ColumnClick (partly provided by you): Private Sub lvwDraws_ColumnClick(ByVal column As ExLVwLibUCtl.IListVi...
by engee30
16 Oct 2013, 20:32
Forum: ExplorerListView
Topic: VirtualMode & MySQL
Replies: 19
Views: 19264

Re: VirtualMode & MySQL

No, you got me right. I'll have a go with your suggestion and let you know how it's worked.
by engee30
16 Oct 2013, 18:11
Forum: ExplorerListView
Topic: VirtualMode & MySQL
Replies: 19
Views: 19264

Re: VirtualMode & MySQL

Okey-doke. Job done. However, I didn't change the class to a type. I had forgotten to compile the project, and had done performance tests in the IDE instead, which produced those poor readings. The cache clears easily and smoothly. I wouldn't be myself if I didn't ask another question ;) This time I...
by engee30
16 Oct 2013, 10:59
Forum: ExplorerListView
Topic: VirtualMode & MySQL
Replies: 19
Views: 19264

Re: VirtualMode & MySQL

Lovely jubbly. Thank you so much TiKu. Works like a charm. The time in which the data loads has now significantly improved. I haven't encoutered any lag while scrolling, so it's fine as is. However, I've got 2 more questions. Is there a nice and easy method to clear the whole cache in an instant? It...
by engee30
15 Oct 2013, 10:38
Forum: ExplorerListView
Topic: VirtualMode & MySQL
Replies: 19
Views: 19264

Re: VirtualMode & MySQL

Okay, here's a small demo. A listview connected to a db and then loaded with some data from the db.
That's basically all I need to deal with. All other functions in the code are related to the content of the listview rather than the db.
by engee30
14 Oct 2013, 23:34
Forum: ExplorerListView
Topic: VirtualMode & MySQL
Replies: 19
Views: 19264

Re: VirtualMode & MySQL

All right, I'll do that. I should upload a sample project tomorrow. Oh, I was lucky this time. I've just found an example of a virtual listview. To my surprise, I was already able to bind it with some data of 1,000,000 items stored in an array 8-)
by engee30
14 Oct 2013, 22:25
Forum: ExplorerListView
Topic: VirtualMode & MySQL
Replies: 19
Views: 19264

Re: VirtualMode & MySQL

Um, basically the database holds all records of the lottery game KENO, which grows by another 420 or so every day. I've got fields for DrawNumber, DrawDate and NumbersDrawn. Right now, I just load everything into the listview, but that takes ages. So the only thing I came up with was to use VirtualM...
by engee30
14 Oct 2013, 20:39
Forum: ExplorerListView
Topic: VirtualMode & MySQL
Replies: 19
Views: 19264

VirtualMode & MySQL

Hello I'd like to connect my ADO Database to the Listview, but in VirtualMode. It's got more than 300 000 entries, so I wouldn't like to load all of them into the listview, but have access to the database and show only those that are set to be visible. Since I've never worked with a listview that ha...