I would like to download usenet messages to my personal Mysql database, so without using any newsreader. At the moment i'm using IpWorks component for .NET . I've created a simple app in Vb.Net, It works, but it's realy slow... to download and to do the INSERT INTO . Anyone know some better method to "massive" download message and insert it into a simple mysql table?
1
There are 1 best solutions below
Related Questions in .NET
- Does compiler optimize operation on const variable and literal const number?
- What is the point of definnig Asp.net Intrinsic Objects In different places and what is the different betwen them?
- Deleting Orphans with Fluent NHibernate
- IOrderedEnumerable to vb.net IOrderedEnumerable Conversion
- What is this namespace ITypeOfObjectsBoundToListBox ? Couldn't find it
- .net rest service with JSON string and consumed with java client
- What is best way to check if any of the property of object is null or empty?
- Telerik's WPF RadColorPicker NoColorText property not working
- Possible consequences of duplicate ProgId for different classes
- How are multiple requests to Task.Run handled from a resource management standpoint?
- Optimizing C++ call from C#
- Make a per-web-application object available to Web API and SignalR controllers
- System.ComponentModel.DataAnnotations.Schema namespace conflict
- LINQ Except/Distinct based on few columns only, to not add duplicates
- Not displaying content by its URL string - absolute urls
Related Questions in MYSQL
- MySQL Select Rank
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Push mysql database script to server using git
- Why does mysql stop using indexes when date ranges are added to the query?
- Google Maps API Re-size
- store numpy array in mysql
- Whats wrong with this query? Using ands
- MySQL-Auto increment
- show duplicate values subquery mysql
- Java Web Application Query Is Not Working
- microsoft odbc driver manager data source name not found and no default driver specified
- Setting foreign key in phpMyAdmin
- No responses from google places text search api
- Adding to MAMP database in SQL/PHP
- I want to remove certain parent- and child-divs in all my wordpress posts with php or some other script
Related Questions in NNTP
- Python 3.4 - NNTPLIB - Port Not Bound - Is there a Firewall Enabled? - Aptana 3.6.1
- Can't get nntp client (nodejs) working
- Java & NNTP : How to post binary file?
- python nntp get headers by date range
- Trying to install NNTP reader tin and parsdate.y error
- is there an alternate to javax.mail.search?
- What are the standard headers in NNTP?
- persist e-mail in a RDBMS
- NNTP server implementation
- Building a tree array from flat array with parent and children nodes sorted by date (aka how to sort a discussion)
- newsgroup nntp protocol talk with fsockopen - how to get size
- Posting large files to usenet using Python & nntplib: How are large files split?
- Python error while connecting to nntp server
- Decoding NNTP headers from (UTF-8?)
- StreamReader doesn't retrieve everything from NetworkStream (TCP and C#)
Related Questions in USENET
- Can't get nntp client (nodejs) working
- Complex searches with bash
- What protocols are used by Usenet? How easily can it be detected by the ISP?
- NNTP server implementation
- Docker failed to bind to $PORT within 60 seconds of launch – HEROKU ERROR
- Turning off adaptive scoring selectively
- Posting large files to usenet using Python & nntplib: How are large files split?
- gnu.mail.providers.nntp newsrc
- NNTP command to get count of available newsgroups
- NNTP usenet download messages
- What is the best way to determine what articles are available for a given usenet group?
- Delphi IdNNTP: download a file from Usenet according to NZB-file
- are USENET or NNTP articles loaded in chronological or reverse chronological order?
- Making a split volume .rar and deleting the source file
- node-nntp get article fails
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You might want to try using a bulk insert or a delayed insert instead of entering items row by row sequentially.
Additionally, a lot of this can be done asynchronously. Most of the work you are doing (writing to the database and downloading the content from nntp) is not bound to resources on your machine. You can perform the downloading and reading of the nntp content in a thread separate from the ones that perform the inserts (you should buffer the content you want to insert before you send it to mysql).
Basically, you want a producer consumer pattern.