Need some C+ Programming done

xardoz · Posted: Thu Nov 24, 2005 4:16 pm Post subject: Need some C+ Programming done

Yes, I know about Rent-A-Coder
But I want people I know for a small project, I have the code written in VB but it lags on a slower machine. I believe, maybe wrongly, that c+ would proform faster.

It is parsing a text file and loading a Access table with data

Anybody interested? $100-$200

Cerulean · Posted: Thu Nov 24, 2005 4:53 pm Post subject:

Hold your horses there. You're better off optimizing the VB code than paying someone for a C++ version. Run your code through a profiler so you can see which sections need optimization - chances are it's not the language.

aschenta · Posted: Thu Nov 24, 2005 6:06 pm Post subject:

Unless the parsing is the slow part i don't see c++ being much faster since the data access is basically the same.

xardoz · Posted: Thu Nov 24, 2005 8:07 pm Post subject:

Yes, it is the parsing part. I thought C was lighting faster than VB, guess I was wrong.... How do I run the code thru an optimizer?

Eric · Posted: Sat Nov 26, 2005 12:53 pm Post subject:

You could post the code and we can take a look at it.

If your text file is in a standard format, then you might be able to connect to it directly with the database methods (you can do that with about any delimited fields).

The only way that other languages are faster in regular parsing is if you can use RegEx for parsing. VB doesn't natively support RegEx.

xardoz · Posted: Sat Nov 26, 2005 9:37 pm Post subject:

I will post the code, but the data is not just simple transfer a dimlimited text into a database fild, some parsing/spliting of data is involved... Confused

xardoz · Posted: Sat Nov 26, 2005 9:50 pm Post subject:

The data is not just simple transfer a dimlimited text into a database fild, some parsing/spliting of data is involved... Confused

Eric · Posted: Sun Nov 27, 2005 3:27 pm Post subject:

Change all your "Mid(strData," to: "Mid$(strData,"

That will give you a small speed boost. Especially since your in a loop.

Next, convert the RS.AddNew into a rs.Execute and use an Insert Query. MEGA speed boost there.

This:

Trim(strFileName) = ""

Should be this:

LEN(Trim(strFileName)) = 0

But since it is outside of your loop, you won't notice a big improvement.

You should also use the StrComp function to compare strings. It will make a small improvement as well. But your biggest boost will come from using a Insert Query, and not the .AddNew (or .Edit) methods.

bdi · Nobody Joined: 21 Oct 2004 Posts: 1646 Location: Chicago

xardoz · Posted: Sun Nov 27, 2005 6:36 pm Post subject:

I have never used an insert Query, could you post an example? Confused

Thank you for the help, each loop is about 4000 records, but the table are disposable

bdi · Nobody Joined: 21 Oct 2004 Posts: 1646 Location: Chicago

sqlConnection.Execute "INSERT INTO Journal (TransCounter, RecordType, ...)" & _
"VALUES '" & strTransCounter & "', '" & strRecordType & "'"

where sqlConnection is your connection object, TransCounter, RecordType, and ... are your field names, and the values variables (strTransCounter, strRecordType, etc) are the values you are plugging in. It's following the Syntax of Access or whatever DB you use and directly runs a SQL statement against it.