Slow VB.NET Application Using A huge data for autocomplete

Question

0.00/5 (No votes)

See more:

Hello,
I have a huge problem when using the autocomplete textbox property with a huge data.
I have tried to load them before application load but the problem is any manipulating on data will not appear to other users unless they restarted the whole application.
The data is more than million record in database.
What I should do to improve my application and the changes appear to the other users not only on local datatable.

Posted 10-Mar-12 23:33pm

Mohammad Nasser Eddin

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wayne Gaylard · Accepted Answer · 2012-03-11T00:37:00

Solution 1

I think you are going to have to use a query to the database as the autocomplete source. This way you avoid having to load all the data before hand.

Posted 11-Mar-12 0:37am

Wayne Gaylard

Comments

Mohammad Nasser Eddin 11-Mar-12 6:40am

thank you for answer
but even if I use a query it will send a query every time the user type a letter and that will make it costs more time and ram. Or what?

Wayne Gaylard 11-Mar-12 6:47am

You are going to have to strike a balance between time and memory cost. What is more important ? A users time or memory use ? The benefit of using a query as the source is that you will be filtering the results right from the get go, and each resultset would get less and less, so you could try only querying for results after the user has typed a specific number of letters. Say you only query the database after the user has typed 3 letters in, then your resultset would be much fewer items.

Mohammad Nasser Eddin 11-Mar-12 6:53am

Unfortunately the time cost is more important to me but the memory cost is very high the Application load cos at least 500 MB of RAM.
The requirement is to search from the first letter, it will filter at most 60% of data and still huge for query from database.
I would like to know if there is a way to make a direct connection between datatable and database with sync, if any change happen on one of them change the other?
and thanks again for helping me :)