Search found 54 matches
- 24 Apr 2020, 08:03
- Forum: Programming
- Topic: Search function - lightning fast
- Replies: 4
- Views: 14505
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...
- 23 Apr 2020, 22:10
- Forum: Programming
- Topic: Search function - lightning fast
- Replies: 4
- Views: 14505
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...
- 16 Apr 2020, 18:10
- Forum: Programming
- Topic: Search function - lightning fast
- Replies: 4
- Views: 14505
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 ...
- 17 Oct 2013, 21:54
- Forum: ExplorerListView
- Topic: VirtualMode & MySQL
- Replies: 19
- Views: 25059
Re: VirtualMode & MySQL
This is it. Another perfect solution did the trick. Cheers, TiKu.
Hopefully, there will be no complex issues with my project.
Kind regards,
Pete
Hopefully, there will be no complex issues with my project.
Kind regards,
Pete
- 17 Oct 2013, 18:22
- Forum: ExplorerListView
- Topic: VirtualMode & MySQL
- Replies: 19
- Views: 25059
Re: VirtualMode & MySQL
Oh that'd be great. I wouldn't have a clue how to do that.
- 17 Oct 2013, 11:03
- Forum: ExplorerListView
- Topic: VirtualMode & MySQL
- Replies: 19
- Views: 25059
Re: VirtualMode & MySQL
It's me again.
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
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
- 16 Oct 2013, 23:33
- Forum: ExplorerListView
- Topic: VirtualMode & MySQL
- Replies: 19
- Views: 25059
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...
- 16 Oct 2013, 21:37
- Forum: ExplorerListView
- Topic: VirtualMode & MySQL
- Replies: 19
- Views: 25059
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...
- 16 Oct 2013, 20:32
- Forum: ExplorerListView
- Topic: VirtualMode & MySQL
- Replies: 19
- Views: 25059
Re: VirtualMode & MySQL
No, you got me right. I'll have a go with your suggestion and let you know how it's worked.
- 16 Oct 2013, 18:11
- Forum: ExplorerListView
- Topic: VirtualMode & MySQL
- Replies: 19
- Views: 25059
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...
- 16 Oct 2013, 10:59
- Forum: ExplorerListView
- Topic: VirtualMode & MySQL
- Replies: 19
- Views: 25059
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...
- 15 Oct 2013, 10:38
- Forum: ExplorerListView
- Topic: VirtualMode & MySQL
- Replies: 19
- Views: 25059
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.
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.
- 14 Oct 2013, 23:34
- Forum: ExplorerListView
- Topic: VirtualMode & MySQL
- Replies: 19
- Views: 25059
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
- 14 Oct 2013, 22:25
- Forum: ExplorerListView
- Topic: VirtualMode & MySQL
- Replies: 19
- Views: 25059
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...
- 14 Oct 2013, 20:39
- Forum: ExplorerListView
- Topic: VirtualMode & MySQL
- Replies: 19
- Views: 25059
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...