.net - Slow Performance When Utilizing Interop.DSOFile To Search Files By Custom Document Property?
Apr 19, 2010
I am new to the world of VB.NET and have been tasked to put together a little program to search a directory of about 2000 Excel spreadsheets and put together a list to display based on the value of a Custom Document Property within that spreadsheet file. Given that I am far from a computer programmer by education or trade, this has been an adventure.
I've gotten it to work, the results are fine. The problem is, it takes well over a minute to run. It is being run over a LAN connection. When I run it locally (using a 'test' directory of about 300 files) it executes in about 4 seconds.I'm not sure even what to expect as a reasonable execution speed, so I thought I would ask here.The code is below, if anyone thinks changes there might be of use in speeding things up.
Private Sub listByPt()
Dim di As New IO.DirectoryInfo(dir_loc)
Dim aryFiles As IO.FileInfo() = di.GetFiles("*" & ext_to_check)[code]....
View 1 Replies
ADVERTISEMENT
Apr 21, 2011
I've got a DataGridView control that is bound to a datatable. The first cell of each row in the DataGrid is a checkbox. When the screen loads all of the checkboxes are unchecked by default. I have a "Select All" button to check all of the boxes. This is performing very slowly when I have a large number of rows in the grid. If I have 1,000 rows it takes over 30 seconds for them all to be checked. When I had 5,000 rows I gave up after 5+ minutes with no result. To check all of the boxes I am looping through each row of the datatable and setting the first item to True:
[code]...
Since that yielded such slow results I changed the logic to loop through each row of the datagrid and set the cell to True but that took three times as long.
Is there a way to quickly "check all" on a large set of data?
View 1 Replies
Mar 16, 2009
I have a program in where I need to loop though the entire dataset.datatable. I takes a long time. What is the alternative I can use to do the some job but faster?
View 4 Replies
Aug 6, 2010
while using VS 2008 SP1 for VB WinForm apps (on Win 7 Ultimate machine),I find that while the performance of VS 2008 is on the slow side, it is generally tolerable except for one thing: when selecting an image for a button, the "Select Resource" dialog will come up, and I choose "local resource", then Import. After navigating to the appropriate folder and selecting the desired image,I will almost always get the "hourglass" (now the blue whirly thing),and only after several seconds will the operation complete(i.e. the "Select Resource" dialog will show the image I selected,and then I can close it and be on my merry way). Typically while the whirly thing is going, the dialog box title will say "Select Resource (Not Responding)". Also on some occasions during the wait period, the Select Resource dialog will hide, and I will have to click the VS icon in the taskbar to make it reappear so the operation can complete.
View 8 Replies
Jun 8, 2012
In my winform application, I have 2 datatables, both contains 37000 rows. Table 1 has 171 columns and Table 2 has 4 columns. A While loop runs to update values in Table 1 from Table 2 for 4 columns. A For loop runs inside While twice to update values. It takes more than 5 min to do so. which i think should be a task of 5 seconds.
Columns being updated are:
Int64 - 1 Columns
String - 1 Columns
[Code]....
View 2 Replies
Apr 2, 2009
I have built an application using VB 2005 express edition with backend Ms Access 2000. In main form(which is loaded on startup), I am having 9 datagridviews, each bound with databindingsources. I am refreshing this data every 15 seconds by refilling the table adapters and updating the datagridviews.Now, this access database is shared in the network and is accessed by about 5-6 users concurrently. There are other forms which are used to edit the data.My problem is poor performance of the application. Its very slow in opening up forms, not responding sometimes and using the network resources fully.
View 5 Replies
Dec 18, 2009
i have a datagridview which have 3 columns, two button columns increase or decrease, 3rd displays the value increased or decreased from button. i have datagridview_CellContentClik behind button columns. The problem is increase in value on pressing button is very slow. i mean if i press button quickly the value should increase quickly but its the same slow pace for increasing or decreasing value on pressing button.
View 2 Replies
Aug 12, 2009
We have a project for a client that is written in VB.NET. In one of the projects, we have about 100 modules, which are all VERY simple. They're extension methods that convert between object types. Here is a small snippet:
Public Module ScheduleExtensions
<System.Runtime.CompilerServices.Extension()> _
Public Function ToServicesData(ByVal source As Schedule) As ScheduleServicesData
[code].....
View 2 Replies
Feb 25, 2012
i am using VB. net 2008. I am having a hard time using this code: ("L:SWPPPSWPPPBookMerge.doc") what is the shortest method that the system will search for the document without placing the document address.
View 1 Replies
Oct 10, 2010
I have some code that is extracting tracked changes from a document. The trouble is its very slow, taking around 60 seconds to capture each tracked change. I originally thought that pagination was slowing down the code (its quite a large word document). However I have turned that off but its made no difference to the speed of the function.
[Code]...
View 3 Replies
May 19, 2011
I have an issue with an Office addin I'm working on, which is implemented for Office 2003 & 2007. The addin is written in VB.NET 3.5 using VSTO.The problem comes from some external code which automates a mail merge, opening the mail merge template, merging and then closing the template document. The close is done with this code:
objWord.Documents(sDoco).Close SaveChanges:=wdDoNotSaveChanges, OriginalFormat:=wdPromptUser
Because of some logic in my addin, instigated from the Interop.Word.Application.DocumentBeforeClose event, a message box is opened which prevents the Office document from closing, which breaks the automation.
Is there a way for me to determine the SaveChanges parameter (if any) on a Close within an Office.Interop.Word.Application event, such as DocumentBeforeClose? I'm trying to capture this parameter and determine if it's set to wdDoNotSaveChanges so that I can work around this problem.
View 1 Replies
Feb 28, 2012
I am creating a wrapper class in .NET (VB.NET as it happens but is equally related to C#) that is exposed to COM and one of the properties I am trying to wrap is a Variant. I thought I would just be able to use an Object, but I get an error: Public Property FieldValue([vFieldID As Object = -1]) As Object cannot be exposed to COM as a property 'Let'. You will not be able to assign non-object values (such as numbers or strings) to this property from Visual Basic 6.0 using a 'Let' statement.*
My property declaration looks like this:
Public Property FieldValue(Optional ByVal vFieldID As Object = -1) As Object
Get
[code].....
View 2 Replies
Mar 11, 2009
I need to set the default property of a dotNet Control used by an VB6 Application.
<ComClass(myControl.ClassId, myControl.InterfaceId, myControl.EventsId)> _
<DefaultProperty("NewProperty")> _
Public Class myControl
[code]....
View 2 Replies
Aug 4, 2011
Im currently debugging my application to found out why it's running a bit slow, when I put breakpoint where i populate one of the application combobox it's run fast but after i populate it and when I'm trying to set the its selectedindex to zero the program halt for about 2 second.. this is the line where the program get stuck for 2 seconds:
[code]...
View 1 Replies
Aug 2, 2011
I am working on windows application form I am having one text box and Listbox. I want if user type on textbox, then List box item is going to be selected, that is working fine. List Box has more than 10,000 records. It takes time to select item from ListBox, while write data in textbox.
[Code]...
View 1 Replies
Aug 16, 2010
So I downloaded the dsofile demo and source from microsoft and up-converted the project to vs9. When I open an office document in the file reader it get the error code 80040154. On Microsft Help and Support there is nothing listed aboutthe code. I tried opening a docx file than a doc file. Also many other file types. I used the uneditied demo of the dsofile and was able to open files.
So how in visual basic 2008 do i use dsofile to get file information. Such as a album of a song from a mp3 file.
View 1 Replies
Jul 11, 2011
I have an ASPX Custom Control which is supposed to load it's properties into an internal collection (defined with PersistenceMode.InnerProperty). Here's the ASPX
<cc:CustomControl runat="server">
<Queries>
<cc:QueryTypeOne ... />
[code]...
View 1 Replies
Jun 16, 2009
I have a problem with a property on a custom property of a class. Here is the actual code for the inherited form
Public Class Form : Inherits System.Windows.Forms.Form
Private _Active_Application As Custom.Classes.Active_Application = New Custom.Classes.Active_Application
<System.ComponentModel.EditorBrowsable(ComponentModel.EditorBrowsableState.Always)> _
Public Property Active_Application() As Custom.Active_Application
[code]....
but when i use a separate class to inherit the above class this property ('Active_Application', not Custom.Classes.Active_Applicaton) is disabled.
View 1 Replies
Nov 30, 2009
I'm not sure if I'm gonna feel like an idiot after posting this, but here goes . I have taken my first shot a writing a code generator. not too shabby for my first go round, but I already see some ways it can be vastly improved. Not there yet, however. One of the things this code generator does is pull text templates (MANY text templates! Over and OVER again!) from a project resource file. I have added them to the resource designer as linked text files.
Now, the way the generator is written, there can at times be a LOT of iteration (think writing property declarations for a Classs which represents a database entity, as well as the backing fields for those property declarations, etc.).
Is there any significant performance hit to repeatedly accessing a resource? I have looked around on msdn and this forum (and will continue to investigate), but I am hoping someone can give me some clarification.
I SUSPECT that use of a resource file means a trip to the Hard drive each time one accesses it . . . Right? It IS a FILE, linked by it's PATH, right? Due to it's having been designated as a project resource, id a resource file somehow "magially" made available in memory, so that the disk round trip is not necessary?
I suspect I should be retreiving popular resources into a persisted Class-level variable if I plan to use them often within a specific class scope, and at the method level if I plan to perform a significant number of iterations whihc require the resource within the method.
AM I on the right track, or is the resource retreival trivial? I am NOT concerned about milking maximum performance out of a generator tool; it is acceptable for this process to take a little time. However, I also don't want to be sloppy unecessarily.
View 2 Replies
Apr 15, 2009
I am currently using the code below within a VB.Net application to find specific text in a Word document. The text is surrounded by symbols represented by the character codes in the .Text statement. The code below is working fine. The issue now is that sometimes the desired text within a document has been marked for deletion and appears as tracked change within the document. I would like to find only the desired text that has NOT been marked for deletion. Does anyone know of a way to determine if the found text is a deletion?
[Code]...
View 2 Replies
Jun 6, 2012
I have been trying to figure out how to read paragraph content which exists a heading. The heading itself is part of the table of contents. The heading will have a particular style (say Heading 1). For example: "Introduction" is a entry in Table of content with style Heading 1. I want to read content under heading "Introduction" but not any more content (i.e not content under sub headings of Introduction) I have been trying to do this using styles/style, TableofContent, Paragraphs/Paragraph,Range. Still cannot come up with a effective solution. I am working in VB.NET in VS 2010. I am using the word 2007 object model (office 2007 interop) as [URL]
View 1 Replies
Jun 25, 2009
If I took a COM object (specifically Excel 2003 workbook) and made it an embedded resource of my executable, would that improve the notoriously slow .NET-COM interop at all?
View 1 Replies
Apr 28, 2011
I am automating Word from VB.Net.I open a document by:
Dim msWord as Word.Application = CreateObject("Word.Application")
Dim doc As Word.Document = msWord.Documents.Add(Template:=Path)
where path points to a template file I created with a header and a watermark. The template has some bookmarks which I want to dynamically set to some appropriate text values:
doc.Bookmarks("DocumentTitle").Range.Text = "The Joy of Office Automation"
If I comment out that line, the document opens in Word with the watermark, etc, in place. If I let that line execute, it inserts the text as appropriate, but the watermark and other things disappear from the document. You can actually see it flash briefly, and then disappear.FWIW, this is Office Word 2007, and I am opening a .Dot (Word 97-2003) template. The Bookmark.Range.Text I am setting is in the document header.
View 2 Replies
Apr 11, 2011
one of the BIG hurdles in my simple project, making a search engine. I don't know how at all. The search engine need only to search in one Directory with its sub directories and txt files for criteria, and display the results, with option open from the results. any basic code or example maybe?
View 5 Replies
Oct 2, 2009
what i am doing is downloading headers from a web server using a tcpclient which works great the headers describe diffrent files and there are hundreads per file, if i download the headers and write them to a text file using a streamwriter it works great, but i need the headers to be in a text file depending on the name of the file in the header, so i need them grouped together, i am now using streamwriter to write the headers to seperate textfiles depending on the filename in the header but it is reallllyyyy slow for some reason, im not sure if it is because it has to load each file then write to it? i only have to append the new header to the end of the text file i dont have to open it up and read through it.
View 8 Replies
Jun 19, 2009
Our current solutions/projects have several classes combined into one file, I'm told this was done due to the slow compile times in VS
View 6 Replies
Oct 3, 2008
I want to only get the values of "Relation1 relationship" and "Relation1 Name". So using the example I would retreive "Father" and "John". How do I use VB 2008 Express Edition to accomplish this? Below is the sample XML document.
Code:
<ANSWER>
- <ANSWER ID="Phone Number">
<VALUE>123-123-1234</VALUE>
</ANSWER>
[code]....
View 1 Replies
Mar 24, 2009
I am new to VB.Net, but I can tell you so far I love programming. That said, I'm building a tool basically to parse and display simple plain text log files. I'm hitting one stumbling block that really has me frustrated.
Other tools are able to load huge log files (500MB even) in a number of seconds. My tool, basically hangs loading a file that is maybe 5MB.
I'm using the MyString = StreamReader.ReadToEnd to read the contents into a string, and then RichTextBox1.Text = MyString to display the contents. That said, I really want to display the contents in a datagrid, but there has to be a better way of doing this?
How can I get my application to load larger files and display them faster? What am I doing wrong?
View 7 Replies
Jun 20, 2010
I have a simple HTML viewer and I would like to add the capability of searching an open document for a text value I specify. Below is an example I found on MSDN. VB gives me an error, "Selection" is not a member of "System.Windows.Forms.Application".
Private Sub SelectionFind()
Dim findText As String = "find me"
Application.Selection.Find.ClearFormatting()
If Application.Selection.Find.Execute(findText) = True Then
[code]....
What I would like to search is the content of a WebBrowser control.
View 12 Replies
Mar 9, 2009
What are the steps & code to make a text searcher in visual basic 2008:...........-I select or load the document in wich i want to search the word
View 1 Replies