Re: Suggestions to reduce memory use when splitting a string

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance




"klineb" <briankline@xxxxxxxxxxx> wrote in message
news:1144088149.283259.318880@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Good Day,

I have written and utility to convert our DOS COBOL data files to a SQL
Server database. Part of the process requires parsing each line into a
sql statement and validting the data to keep the integrity of the
database. We are parsing roughl 81 files and range in size 1 kb to 65
MB files (Average of 400,000 lines in the larger files).

I have written this utility with VB.NET 2003 and when I parse all of
the files I run out of memory. The following functions seems to be the
main source of my leak. Any help optimizing this code is appreciated.


There are a few tweaks you can apply here to reduce memory utilization (in
particular you can perhaps reuse the StringBuilders). However there's
nothing obvious and terrible here. In short this function should not cause
an out of memory error.

David


.



Relevant Pages

  • Re: Recordset Not Updatable
    ... > Server database, ... I was correcting and enhancing the ADP front-end to SQL ... updates by executing individual SQL statements for each control/field that ... But, as Sylvain says, there are many reasons why a recordset is not ...
    (microsoft.public.access.adp.sqlserver)
  • jtds driver and SQL Server performance problem
    ... I am using the opensource jtds driver to retreive information from an SQL ... The java application and the SQL Server database both ... Both tables are fairly large (approx. ...
    (comp.lang.java.databases)
  • Re: SQL Server 2005 Restore Error
    ... then the SQL Server Express edition only support ... Export data from the client database(Place the exported file to FTP ... location.)and import it in server database using SMO. ... and execute the sql file from server database using SMO. ...
    (microsoft.public.sqlserver.server)
  • Re: Setting file permissions
    ... You can use the Run method of the wshShell object to run the osql command ... This is for SQL Server databases. ... If the SQL Server database is in the default instance, use "-S MyServer", ... Set adoConnection = CreateObject ...
    (microsoft.public.scripting.vbscript)
  • RE: Performance related question
    ... Improving the SQL is always a performance boost. ... Parsing requires latches, ... >> optimising a few lines of Perl. ...
    (perl.dbi.users)