I wrote a VB.net console program to process CSV record that come in a text file. I'm using FileHelpers library
along with MSFT Enterprise library 4. To read the record one at the time and insert into the database.
It took about 3 - 4 hours to process 5+ million records on the text file.Is there anyway to speed up the process? Has anyone deal with such large amount of records before and how would you update such records if there is new data to be update?
edit: Can someone recommend a profiler? prefer Open source or free.
How do i exactly check internet connection speed.I have searched around google and found out a method w/c will Download a file like 1mb size, then it will calculate the speed.
I have the following script where a user fills out a form and the data is passed to update a row in an existing excel document. Everything works fine, but its excruciatingly slow. how to speed this up?
Dim oEx As Excel.Application Dim oWk As Excel.Workbook Dim oWt As Excel.Worksheet
i have some code in visual basic and i wrote some classes in c++ and i want make it dll but i don't know that when you use dlls it decreases the speed of process or not.
I have a codes that calculates DownLoad speed and UpLoad speed kb/s. I would like to implement this kind. I also want to put such kind of graph. Any article or links where can I start building my own like that.
When I load my solution and compile it after first starting the IDE, everything works as expected. After changing source and recompiling, I get the following compile error:
Error 11 Unable to copy file "objDebugCAMDRS.Library.dll" to "binCAMDRS.Library.dll". The process cannot access the file 'binCAMDRS.Library.dll' because it is being used by another process. CAMDRS.Library.
After closing Visual Studio 2005 and reopening the solution I can compile again successfully. This is an old solution that has been fine for a long time. I just recently changed computers and reinstalled everything.I am running win XP Pro sp2, Visual Studio 2005 sp1.
My program writes to a .txt file (and this is the ONLY program that writes to it) in a thread (with lowest priority), but every now and then it gets an error "The process cannot access the file because another process has locked a portion of the file" when it executes this code: swLog.WriteLine(sPacket).Other program reads from the file, not write to it, why do I get this error, and how can I get around it, or what shall I do when I get this error since I can't write to the file ?
The process cannot access the file 'C:UsersdavidDesktopTest Folderdavid 2.xml' because it is being used by another process.
how do i end the prosess after I create the file? Or am I creating it in the wrong manner.The underlined line is where the error ocures.
Public Sub AddDTData(ByVal value1 As String, ByVal value2 As String, ByVal filename As String) dtUser.Rows.Add(value1, value2, Now.Date) If My.Computer.FileSystem.FileExists(filename) Then
I try to open a text file and write in some text, when i run the program it says the following error:The process cannot access the file 'D:VB projectsCategory_Characteristics.txt' because it is being used by another process.
THe code is as follows and the error hits in line :
Dim objWriter As New System.IO.StreamWriter(FILE_NAME) ----------------------------------------- Dim FILE_NAME As String = "D:VB projectsCategory_Characteristics.txt"
How can i access a file through FileStream which is being used by a window service. Actually i am trying to access a file which is also being used by our window service. I need to read data from this file. I am using below code but also getting following error:
Code: Dim fs1 As IO.FileStream = New IO.FileStream(psPath, IO.FileMode.Open, IO.FileAccess.Read, IO.FileShare.Read) Dim sr As IO.StreamReader = New IO.StreamReader(fs1) sData = sr.ReadToEnd
Error: The process cannot access the file 'FILENAME' because it is being used by another process.
I tried changing FileShare.Read parameter to FileShare.None but it didn't work out. I also read below post which says that it is not possible but i think there is a way to read it like if you open a file through Firefox but still window service is accessing it.
I am working with saving and deleting images. What i really want to do is check and see if an image exists in the destination folder and if it does automatically overwrite it. i couldnt figure that out so i figured i would look to see if the file was there if it is Delete it then write the new file..The issue is i keep getting this error.The process cannot access the file "FileName" because it is being used by another process. [code]
The process cannot access the file 'C:UsersJoshuaDocumentsTest1.txt' because it is being used by another process.Now the Problem. When i step through my code, it will do as intended, e.g. clear all contents of test1.txt. when i run it at run time it throws this error. The reason for it throwing an error is the text file is reading string, int, string, and the txt file has a string including in the int part, so i'm making it so you can empty a corrupt file.
vb Imports System.IO Public Class Form1 Private norepeat As Boolean
I made a GIF file by Easy GIF Animator 5.0. The GIF file has 33 frames, with 1/100s per frame. That means the GIF length is 0.33s. However, if I use picturebox (and even view by Windows Picture and Fax viewer) to load that image, it lasts for more than 1.5s. If I use ACD See, it show exacly 0.33s. How can I do like ACD See?
this process problem only happen when i add the line below (red colored (line 12 and 19))the error pointed at the colored (blue (line 32)) at saving the image to the database
here's the code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click OpenFileDialog1.Title = "Set Image File" OpenFileDialog1.Filter = "JPEG Files|*.jpg" OpenFileDialog1.DefaultExt = "bmp"
I have a ftp download in a background session that updates to a progressbar, file download takes about 2 minutes and it works great, gives me the length that has been downloaded, total size, and the bytes remaining.I thought it would be cool to have the speed show as well but not sure I have all the info to work with, or how exactly to do it. This is my loop, and what I do have works fine just want to have the speed show as well if possible:[code]
I am new to vb and I am required to plot a graph in vb. I need to get data from a text file to plot a polar graph of Wind Direction vs Wind Speed. But opening the file from a text file is in a string format, and when i tried to convert to a double, it gives the error:
I have an app that reads a directory to get the filenames in a directory for each File in Directory(process file) next file. I want to know if the file size makes a difference to the time it takes to get the filenames.eg if a folder contains 10,000 photos of 1 megapixel and another has a folder of 10,000 photos of 8 megapixels will it take the same time.
It has the ability to recursively grab all .wmv and .mp3 files in any chosen folder, and add them to a playlist.When opening the playlist, my program adds all the songs to an array, then starts adding the songs to a listview, categorizing them by song, artist, album, and genre, using a dll to access the ID3v1 tags on the .mp3 file.It can successfully create playlists of thousands of songs at a somewhat okay speed, the problem is loading that into the categorized listview.It used around 75% of my friend's CPU while loading his 5k+ song playlist into the listview, and it never finished after loading it in for a couple minutes (it auto updates as it loads, because it is done in a new thread.) It never finished because his OS has a bug where, if the CPU usage is over 100% for more then a few mins, it BSOD's, but that's beside the point.
His CPU, by the way, is a quad core 2.33 GHZ processor.The listview loads thousands of songs by using a lot of CPU [low amount of RAM, less then 40MB 99% of the time], and it does it slowly. [code]I've already redone the sub once or twice to speed it up, and at the moment it's 2-3.,
when i'm running the update it shows the error The process cannot access the file 'C:Documents and SettingsMackyMy DocumentsVisual Studio 2008ProjectsMarcelo 2.2.3MarceloinDebugStudentsMIC953867.jpg' because it is being used by another process.
[Code]...
I can save new student information with picture.. but when it comes in updating the picture these codes didn't work......
Imports HR.EZTwainLibrary Imports System.Runtime.InteropServices Public Class frmNewScan
[Code].....
this problem occurs when i scan an images for the second time. i think the error is my filename(C:MyImage.jpeg). how can i have a different filename thru coding or how to delete the tempory filename of an image to make scan again.
I am adding images to a FlowLayoutPanel control via the following code
Dim WithEvents Pedit As DevExpress.XtraEditors.PictureEdit Private Sub LoadImagesCommon(ByVal fi As FileInfo) Pedit = New DevExpress.XtraEditors.PictureEdit
I have created a Windows service in VS 2005 that monitors a folder for XML files, reads some data elements from the XML using XmlDocument, then copies the files to another location. I find that when I drop 2 or more XML files into the folder simultaneously, it processes them with no problems, but when I drop the same files into the folder one at a time, I will get an error on the second file: "The process cannot access the file <my file> because it is being used by another process." If I stop my service, restart it, and drop the second file into the folder again, it works the second time. I am confident that no other program is accessing this file at the same time as my service. My impression is that the processing of file # 1 is somehow not releasing all of the resources, leading to the processing of file # 2 mistakenly thinking that it can't access that second file.
Dim FileWatcher As New FileSystemWatcher() It points the watcher to my folder, sets up an event handler, then enables the watching: FileWatcher.Path = InputFolderPath
I am trying to write a Windows Script that will allow me to monitor the following: That 2 x seperate but specific processes within Component Services "Running Processes" list are currently running and have not reset within the past hour. If I already know the PID, then I can retrieve the CreationDate (I assume which I can use to check for restarts? or is this the actual process creation/installation date) for each specific process, however if a restart occurs the PID will change and my script needs to know what the new PID is without me telling it!