473,324 Members | 2,124 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Multi-Threading

I am having problems with Multi-threading and write to Key Access
Database

I have a log file that and collecting infomation from

getting the info is a problem or is writing it the database, the log
files a big and it takes time to read down as it get further in to log
said, a 100,000 line in

I have changed it to mutli-threading which almost works, the problem
is when writing data to the table. I get dup keys and the whole
stops, this does not happen with the single thread app.

basically i want each thread to wait until thread before finish its
write to the database.

ie.
thread 1 waits for thread 0 to finish writing to table
thread 2 waits for thread 1 to finsih writing to table
thread 4 waits for ..........

during this each for the thread have collected the data they need to
write to the table.

Here is the line code to

Dim intcount As Integer = 1, intcount1 As Integer =
fNoOfLines(fileNm)
Dim AppThreads(4) As Thread
Dim WebData(intcount1) As DoWork

Do Until intcount intcount1

WebData(Thread) = New DoWork

'################################

Code collecting data is here
################################

'# Setup and start new thread
AppThreads(Thread) = New Thread(AddressOf
WebData(Thread).sWriteWebUsage)
AppThreads(Thread).Start()
System.Threading.Thread.Sleep(15)
intcount = intcount + 12
Loop

I removed all the code that does the data collecting as it works
fine,

I believe my problem is at the Appthreads(thread).start()
Feb 13 '08 #1
3 1426

"Guru" <ru*****@interference.nitwrote in message
news:1k*************@news.alt.net...

<snipped>

Oh, and one other thing, what if the application was using SQL Command ,
Business and Data Access Layer objects and there was no DataTable in the
solution period in your narrow you are a real programmer mindset.

Let's get your vast expertise on that, since you needed to run your mouth.
One shoe doesn't fit all situations. And as far as I am concerned, you were
totally out of line here.
Feb 13 '08 #2
"Mr. Arnold" <MR. Ar****@Arnold.comwrote in message
news:e5**************@TK2MSFTNGP05.phx.gbl...
>
"Guru" <ru*****@interference.nitwrote in message
news:1k*************@news.alt.net...

<snipped>

Oh, and one other thing, what if the application was using SQL Command ,
Business and Data Access Layer objects and there was no DataTable in the
solution period in your narrow you are a real programmer mindset.

Let's get your vast expertise on that, since you needed to run your mouth.
One shoe doesn't fit all situations. And as far as I am concerned, you
were totally out of line here.
The solution is as simple as you are... fix the SQL.

Eat that, cat cornholer.
Feb 13 '08 #3

"Guru" <ru*****@interference.nitwrote in message
news:eB**************@TK2MSFTNGP05.phx.gbl...
"Mr. Arnold" <MR. Ar****@Arnold.comwrote in message
news:e5**************@TK2MSFTNGP05.phx.gbl...
>>
"Guru" <ru*****@interference.nitwrote in message
news:1k*************@news.alt.net...

<snipped>

Oh, and one other thing, what if the application was using SQL Command ,
Business and Data Access Layer objects and there was no DataTable in the
solution period in your narrow you are a real programmer mindset.

Let's get your vast expertise on that, since you needed to run your
mouth. One shoe doesn't fit all situations. And as far as I am concerned,
you were totally out of line here.

The solution is as simple as you are... fix the SQL.

Eat that, cat cornholer.
Yeah right -- LOL, don't put your John Brown behind parts in my face you
young lunatic American. Now, you go crawl back into your hole that you came
out of acting like a crazy person.

And one wonders why the rest of the world hates America. Well, with
lunatics like you running around in it ready to play cowboy and attack
anything that moves with no provocation, I see the reason, and I am
American. :)

Feb 14 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Frank Jona | last post by:
Intellisense with C# and a multi-file assembly is not working. With VB.NET it is working. Is there a fix availible? We're using VisualStudio 2003 Regards Frank
12
by: * ProteanThread * | last post by:
but depends upon the clique: ...
0
by: frankenberry | last post by:
I have multi-page tiff files. I need to extract individual frames from the multi-page tiffs and save them as single-page tiffs. 95% of the time I receive multi-page tiffs containing 1 or more black...
6
by: cody | last post by:
What are multi file assemblies good for? What are the advantages of using multiple assemblies (A.DLL+B.DLL) vs. a single multi file assembly (A.DLL+A.NETMODULE)?
6
by: Joe | last post by:
I have 2 multi-list boxes, 1 displays course categories based on a table called CATEGORIES. This table has 2 fields CATEGORY_ID, CATEGORY_NAME The other multi-list box displays courses based on...
4
by: mimmo | last post by:
Hi! I should convert the accented letters of a string in the correspondent letters not accented. But when I compile with -Wall it give me: warning: multi-character character constant Do the...
5
by: Shane Story | last post by:
I can seem to get the dimensions of a frame in a multiframe tiff. After selecting activeframe, the Width/Height is still really much larger than the page's actual dimensions. When I split a...
5
by: bobwansink | last post by:
Hi, I'm relatively new to programming and I would like to create a C++ multi user program. It's for a project for school. This means I will have to write a paper about the theory too. Does anyone...
0
by: Sabri.Pllana | last post by:
We apologize if you receive multiple copies of this call for papers. *********************************************************************** 2008 International Workshop on Multi-Core Computing...
1
by: mknoll217 | last post by:
I am recieving this error from my code: The multi-part identifier "PAR.UniqueID" could not be bound. The multi-part identifier "Salary.UniqueID" could not be bound. The multi-part identifier...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.