StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5462774
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-03-28T17:33:37.670
FavoriteCount
0
LastActivityDate
2011-03-28T17:33:37.670
LastEditDate
LastEditorUserId
0
OwnerUserId
355931
ParentId
2953955
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
After some time of brain breaking, I figured out my own mistakes... I want to put this new knowledge, so... here I go I made a very big mistake by declaring the Connection objet as a Static object in my code... so obviously, despite I created a new Connection for each new data object I created, every transaction went through a single, static, connection. With that first issue corrected, I went back to the design table, and realized that my process was: <ol> <li>Read an Id from an input table</li> <li>Take a block of data related to the Id read in step 1, stored in other input tables</li> <li>Crunch numbers: Read the related input tables and process the data stored in them</li> <li>Save the results in one or more output tables</li> <li>Repeat the process while I have pending Ids in the input table</li> </ol> Just by using a dedicated connection for input reading and a dedicated connection for output writing, the performance of my program increased... but I needed a lot more! My original approach for steps 3 and 4 was to save into the output each one of the results as soon as I had them... But I found a better approach: <ul> <li>Read the input data</li> <li>Crunch the numbers, and put the results in a bunch of queues (one for each output table)</li> <li>A separated thread is checking every second if there's data in any of the queues. If there's data in the queues, write it to the tables.</li> </ul> So, by dividing input and output tasks using different connections, and by redirecting the core process output to a queue, and by using a dedicated thread for output storage tasks, I finally achieved what I wanted: Multithreaded DML execution! <hr> I know there are better approaches to this particular problem, but this one works quite fine. So... if anyone is stuck with a problem like this... I hope this helps.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHelp with java threads or executors: Executing several MySQL selects, inserts and updates simmultaneously
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USBarranka
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHelp with java threads or executors: Executing several MySQL selects, inserts and updates simmultaneously
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.