Dear All,
HAPPY NEW YEAR 2009!
Today, I would like to ask help about the handling of output of OpenSees. In my work, I am recording all the information of nodes and my model contains huge number of nodes. When I got the output file, the file size is around 300 MB. It is really a huge text file to do post processing. So, I think it is better to use some database like MySQL. I can insert the data from ouptput text file to mysql database but its very long time in that way. So, I need help to directly insert the output data into mysql through opensees. Please help me how I can insert the output information of node, members... in mysql database.
If you could give me the source code that can do such function, it would be great help. Since, I don't know much about c++ programming so I cannot edit the source code of OpenSees Myself.
Thank you
Recorder output in Mysql Database
Moderators: silvia, selimgunay, Moderators
Recorder output in Mysql Database
Deepak Rayamajhi
Graduate Student
Oregon State University
Graduate Student
Oregon State University
Hello everybody,
Finally, I solved my problem. I got 2 Gegabytes data from the 3D analysis of building, just for one analysis.
Initially I was trying to insert the outdata into MYSQL server using insert command of mysql from VB.net. I found that this proceessing taking too much time. It took me 3 hr to load only 1.5 Gigs data into database.
Later, I tried to rearrange the output file of opensees into mysql command format " LOAD DATA from FILE..." .
And I saved my time, It took my only 10 minutes to insert all my data into mysql database.
For post processing of my analysis I made program in vb.net and I am using Mysql for database handling.
Thank you again!!
Deepak Rayamajhi
Finally, I solved my problem. I got 2 Gegabytes data from the 3D analysis of building, just for one analysis.
Initially I was trying to insert the outdata into MYSQL server using insert command of mysql from VB.net. I found that this proceessing taking too much time. It took me 3 hr to load only 1.5 Gigs data into database.
Later, I tried to rearrange the output file of opensees into mysql command format " LOAD DATA from FILE..." .
And I saved my time, It took my only 10 minutes to insert all my data into mysql database.
For post processing of my analysis I made program in vb.net and I am using Mysql for database handling.
Thank you again!!
Deepak Rayamajhi
Deepak Rayamajhi
Graduate Student
Oregon State University
Graduate Student
Oregon State University