|
in my app i want to read huge no of records(100000) from the db using one connection. i want to do this using threads, how can i get the data in parallel. but the problem is how to tell one thread to get specified range of data(ex : thread1 ->1-1000,thread 2 ->1001 to 2000) etc.
|
|
|
|
|
Im no expert on this but if your only using one connection then surely the data transfer can only handle one query at a time? therefore using multiple threads would be slower than one thread, as each thread would have to wait for the other to finish with the connection, the reason i say 'slower'is because you would need additional checks to determine when another thread has finished
|
|
|
|
|
as i know that using one connection we can do multiple database calls.the problem is using one connection how to retrieve data from the same table,to listview is there any other way to solve this.
|
|
|
|
|
prasadbuddhika wrote: we can do multiple database calls
Not at the same time, you'd need multiple connections.
System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.
You may not get much of an improvement anyway, because the network IO may be the slowest link.
|
|
|
|
|
prasadbuddhika wrote: i want to read huge no of records(100000) from the db using one connection. i want to do this using threads, how can i get the data in parallel
In order to do this, you must use multiple connections, one for each simultaneous access.
prasadbuddhika wrote: problem is how to tell one thread to get specified range of data
Use BackgroundWorker and RunWorkerAsync method. Create a simple class which holds the data for you (range start and amount of data) and pass that to the RunWorkerAsync method.
Warning, it's very likely that this will be slower than fetching all at once. Especially if you're going to use the amount of records as the range (instead of for example primary key values), the throughput will be catastrophic.
|
|
|
|
|
thanx,i would like to know how huge amount of data retreived in most situations, do they use one connection always to do this or is there any other way to do this in industry level.
|
|
|
|
|
prasadbuddhika wrote: in industry level
By not retrieving huge amounts of data.
|
|
|
|
|
The most important thing is to retrieve only what you need. Don't fetch data from the database and then eliminate rows and discard data on client side. That will lead to performance problems. Use the capabilities of SQL language. SQL language and database engines are developed from 1970's so by now they have very sophisticated mechanisms to optimize data retrieval to get you only tehat you need in decent time.
|
|
|
|
|
ArrayList al = new ArrayList();
al.Add("#98,yuyu street,,,");
al.Add("#55,ty road");
how can i pass these two values as input seperately... pls help
the quieter u become more u hear
|
|
|
|
|
You can pass these values via al[0] and al[1].
|
|
|
|
|
Dear All,
I want to parse Check Update Request (wbxml) Could anyone help me for that. I am able to receive check update request in my C# Web site.
It will be greatfull, If any body can help me.
 Thanks you lot in advance.
Manoj Kumar
|
|
|
|
|
check the following CodeProject article[^]
"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)
|
|
|
|
|
Hi all,
I have to find out the spelling mistakes from the words which is typing by user in rich text box.if spelling is wrong i need to mark that word with red under line.how can i do that? Can any one help me plse........??
Thanks in advance.
Regards
Lijo
|
|
|
|
|
Look into the WPF rich text box, that has an option to set spellCheck to true or false. that can handle the red line and suggestions for you.
If you doing windows forms, you may want to use an elementhost control to put the WPF richtextbox in.
I made a small customControl which had an elementHost that set a WPF RichTextBox up inside it
|
|
|
|
|
i am using .net 2.0 then how can i use WPF? can u plse tell me how to do it in .net 2.0?
|
|
|
|
|
Im a bit busy at the min to go into depth, will post more detail in bout 1.5 hours, so hope you can wait
|
|
|
|
|
Sure i can wait for u......
|
|
|
|
|
OK so you need atleast 3.0 for what I suggested. I dont know for sure but can you not just include the relevant 3.0 library files with your application and reference them?
Also its not unrealistic to expect users to upgrade there .Net version to meet application requirements.
Anyway if your sticking with 2.0 then there was an alternative solution I tried before using the WPF approach. That was to have a text file with all dictionary words:
I cant remember which one i used but here is one example:
Dictionary Words[^]
Im sure you can see where this is going now -
Create function that tests all words in the richTextBox with the .txt file and then highlight any words that dont match, i set the text color to red as there no option for the red underline. I think you would have to handle the paint for that, which is prob more hassle then its worth.
Also I choose to have a button to perform the spell check rather than auto check when text changes because of the performance. Of course one could make my attemp more effecient im sure, I didnt bother as I found the alternative WPF approach instead.
I didnt handle the spelling suggestions as the algorithms seemed a bit complex but there were some good explainations for how to do it out there
Hope this helps in anyway
My opinion is... If someone has already posted an answer, dont post the SAME answer
|
|
|
|
|
You can use .NET 3.0 in VS2005, otherwise you can't. The other option for spell check is to interfaec with Word, of course then your users need to have Word.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
There are several SpellChecking libraries available you can use to check what the user types.
|
|
|
|
|
Hi guys.
I'm going crazy from searching the Internet for solutions.
how do i extract the domain from a URL or Uri
the host name (Uri.Host) is not good enough since i want to remove all sub-domains.
i found a few regex solutions but all are for single top level domains like .com, .org and .net but i need a solutions for co.uk and all domain types.
I'm creating a app that allows browsing for certain domains that the user could choose, the user could add "*.google.co.uk" to allow all sub-domains of google.co.uk but i can't compare "search.something.google.co.uk" to match "*.google.co.uk" since i can't extract the domain only.
Please if any one knows a solutions for this, or how to compare a host to a wildcard domain please reply.
Thanks
|
|
|
|
|
IM not sure how the Uri.Host string displays or the different types of addresses you could get, so i cant suggest a methofd for parsing.
But you could split the string with '.' and then loop the results for a match to pre-defined values. i.e. if one value is 'Google' then its a google website etc. Again im not sure how reliable this would be but it could be a temp solution till you find a better way
|
|
|
|
|
|
OK then:
make a list of all '.com' '.co.uk' (whatever you call them) in the world.
then search your uri for a match and the domain should be the split before the '.com' etc
Thats a solution, right?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
