I've found the following code in my boss's project:
Dim strBuilder As New System.Text.StringBuilder("", 1000000)
Before I call him out on it, I'd like to confirm whether this line actually sets a megabyte (or two megabytes in Unicode?) of memory aside for that one stringbuilder?
So, I have this code that grabs a bunch of data from the database, and performs a bunch of calculations on that data. However, this is not what is causing the halt. The halt is coming in when I take all that "final" data that has been prepared, and go to write that into a text file.
Each line in the text file is being created from data that has had calculations performed on it. Each line "corresponds" to a record from the database. A user will have to perform this file export usually on about 30-40 thousand records at a time. Now, even though I am using a StringBuilder, this still halts because of the pure mass amount of records.
What I do currently in the code is create one StringBuilder, append all the data (after calcs) to it, convert it to a String, add it to a List(Of String) to be returned from the Function, and then clear the StringBuilder, and do the same for the next row, and I do this until each row has been created and appended, converted, and then inserted into the List.
Then, another class receives this List(Of String) and takes each String and eventually appends it to a file.
Does anyone have an idea of how to improve this code and make it so it doesn't halt the server every time? The reason it wasn't found out until now is because when I tested it locally I was testing it on only 1-50 records at a time.
[Code]...
I am facing an amazing problem in my application. On my Developement server when I am running my application, then there is one function where I am trying to put whole stringbuilder contents in a string object. This Function is used for paging the reports.For that I am using a method of Stringbuilder.tostring() and when I chek the value of this statement (stringbuilder.tostring()) it shows no such interface is supported, which later on throws exception of system is out of memory. Here i am using .net 2.0 framework and sql server 2005 database.But when I run the application on stagging server then there is no such exception thrown.[code]
View 3 RepliesI would be grateful with some help with reading a text file into a Richtext box. The code I have at present appends the first line of text as I want it but the rest of the lines of text do not alter. I need a loop to read to the end of file and display in Richtext box. the code i have at present is this:-
[Code]...
Would the world of strings be better if stringbuilder had IndexOf?
View 2 Repliesuse the following code to create a database in ms access
Code:
'reference: Microsoft ActiveX Data Objects 2.8 Library
'reference: Microsoft ADO Ext. 2.8 for DDL and Security
[code].....
If I have a very large function/sub in a class that is an instance method (i.e., not Shared), do I gain or lose anything by moving that to a shared method and then declaring a small stub method for the instance use?
I.e., I go from this:
Public Sub MyBigMethod(ByVal Foobar As String)
If String.IsNullOrWhitespace(Foobar) Then
Throw New ArgumentNullException("Foobar")
End If
[Code] .....
My thinking is I save on memory size per each instance of the object. Because each instance only has to lug around the stub method which handles calling the shared version and passing an instance of itself to the shared method so that it can do whatever it needs to do. But I'll wager that I sacrifice a very teensy amount of speed because of the added function call overhead.
Out of Memory displaying Thumbnails in Windows 7 64-Bit with 12GB installed
See more: .NET4
'My VB Code:
Private Sub Thumb()
Dim img As Image
[Code]...
1. How many elements an array list can store in VB.NET?2. Upon what factors the stroing capacity of arraylist depends?
View 4 Repliesis it ever possible for a dictionary to hold more than 2147483647 items?
which exception do we get if we try to add to a dictionary with already 2147483647 items?
The limit of an access database. Because I only know of manipulating access 2003 database with vb.net. And were going to make an information system for a small hospital for our project. Is ms access still usable for a hospital with over 2000 patients per year? some database if the ms access that I'm using no longer fits for our project.
View 6 RepliesI created setup file by setup project. I attached with mdf, ldf files in it , SO CAPACITY OF IT AFTER PACKING IS QUITE BIG.I want to reduce its capacity. How can i do that I see some other Setup projects which have attached with mdf ,ldf files but It is not big as SetUp file of me.
View 2 RepliesIs there any way to Detect video card infomations ? i want to connect to the registry (regedit) that contain my video card infomations . i also get lot of infomations via registry like cpu ,speed,motherboad info ..but i can't find the video card infomations.
View 4 RepliesI would like to check the free space of a server share (\servershare) Is this a simple task and how would I do it?I found the following for a mapped drive, but it does not seem to like server names.
Dim cdrive As System.IO.DriveInfo
cdrive = My.Computer.FileSystem.GetDriveInfo("C:")
MsgBox("Total free space: " & CStr(cdrive.TotalFreeSpace))
If I increase the capacity of a given list, or add elements until count>capacity, does this mean the program is actually copying the entire list's contents to a new space in memory (similar to redim preserve with arrays)? If so, than I have really been hurting the performance of my lists, as before I was inserting and adding without a second thought. This seems a strong restriction on the dynamic abilities of lists.
View 2 RepliesI want to write a program to do Markov chain, but my states are quite large. First of all I calculate all the transition probabilities and revenues for all states(1381860 total states), and store in a multidimensional array. Public RevArr(0 To 9, 0 To 750, 0 To 282) As Long
After that the iteration of markov chain should use these as inputs to calculate the steady-state probabilities. But when I try to run the main code I got this error.Exception of type 'System.OutOfMemoryException' was thrown.
The following is the declaration of second array I add just another dimension for storing all the iterations, but I get this error. Dim stateprob(IT + 1, 0 To 9, 0 To 750, 0 To 282) As single
Is there some way of changing the capacity of the Resource folder to compile with a large capacitance...
View 1 RepliesI'm using VB's StringBuilder, and I was curious what is considered "best practice" for emptying the builder/setting it to a new string. Would it be something like this:[code]or is there a "Better" way?
View 2 Repliesi'm using string builder for generating Passenger List in which i have used a tables i want to add dropdownlist into this Passenger . what i did is i have taken one main table --
strHTML1.Append("<table align=center cellpadding='0' cellspacing='0' width='100%'>");
strHTML1.Append("<tr>");
strHTML1.Append("<td>");
strHTML1.Append("Passenger");
[code]....
the prob is it is not show the dropdownlist when i run the project.
I'm trying to find out an easy way of bolding a string of my stringbuilder...if that is even possible.The stringbuilder eventually passes all the text to richtextbox..I'd like to bold this string
sb.AppendLine("--------------------------------")
and also
sb.AppendLine("Results for " & finalname)
[code].....
I am having the following string builder as msrtResult, which is quite long:
mstrResult.Append(rtbResult.Text).Append("})})" + Environment.NewLine)
How can I remove the last "," from mstrResult Now? (it is in the middle of that mstrResult and it is not the last character of the whole string since I am appending strings to it)I should do it before adding the newline.
I want to keep away from string object. I have a stringbuilder object, and I want to know if it contains 'Firefox'.
View 6 RepliesI have a sub that takes a string, replaces all characters that are not alphanumberic and or a "/" and replaces it with a space. Then it goes through and replaces all multiple spaces with a single space.
Right now I am using a string builder to do this. My problem is that this action must be done several hundred to thousand times depending on the filesize I am comparing it to (1 richtextbox line = 1 string)
I believe I should see a significant increase in performance if I can figure out how to do this using a single regex.replace function.How would I go about constructing a regex.replace function that would keep all alphanumberic characters and "/" and replace everything else with a single space?
[Code]...
I've got a stringbuilder variable, that I want to return the contents of, but if it's empty I want to return "|", so is it best to use stringbuilder.tostring in the compare statement e.g
If lReturnStringBuilder.ToString = String.Empty Then
lReturnStringBuilder.Append("|")
End If
[code].....
do you also have to use StringBuilder when declaring a String like this?:
View 11 RepliesStringBuilder exists purely for the reason that strings in .NET are immutable, that is that traditional string concatenation can use lots of resources (due to lots of String objects being created).So, since an Int32 is also immutable why don't classes exist for multiple addition for example?
View 4 RepliesHow can I check if a StringBuilder contains a certain character or string? There is no Contains method like the string class has.
View 8 RepliesSuppose a stringbuilder is delimited by tab, I want to convert it to a matrix. How to do it?
View 3 RepliesI have a textbox in which i have to write content inside stringbuilder.Following is my stringbuilder.
Dim strString As New StringBuilder()
strString.AppendLine("<table>")
strString.AppendLine("<tr><td>")
[code].....
vb.net
'strSearch = textBox.Text, columns 2 to 10 are the optional columns you want to search to. Function WhereQuery(ByVal strSearch As String, ByVal column1 As String, Optional ByVal column2 As String = "", Optional ByVal column3 As String = "", Optional ByVal column4 As String = "", Optional ByVal column5 As String = "", Optional ByVal column6 As String = "", Optional ByVal column7 As String = "",[code]..
sample output:
im also thinking on using stringbuilder to replace my strings.