Home » Modeling » EMF » [CDO] Raw writes in DB (MySQL)
| [CDO] Raw writes in DB (MySQL) [message #989763] |
Fri, 07 December 2012 11:08  |
 Christophe MOINE
Messages: 28
Registered: February 2012 |
Junior Member |
|
|
Hello,
I first want to apologize to re-open this discussion that I posted one year ago:
I wanted to load large amount of data when initializing the database (150.000 rows), but now we added about 400.000 rows at the initialization process.
I thought about some workarounds, but don't know which one make sense, and which one is safe:
- Make an SQL dump of the concerned tables: should be quick, but annoying to maintain imho (since data are updated monthly...), and doesn't handle nicely the meta model changes (maybe more a feeling than reality).
- Insert directly data in the SQL base, but seems quite risky. Even if we start understanding the CDO data model, we still can miss some subtilities, and we have to ensure that CDO don't use any cache, etc....
- The initialization code runs into the same VM as the CDO Server: isn't it some ways to use directly CDO raw layer classes to initialize the base properly without using the Net4j/Network communication overhead ? For the moment I create a CDO Client into the CDO Server process to initialize the database, but I don't think it is optimal...
- Other ideas... ?
The thing is that my C++ co workers laugh at us because our initialization process takes about 10 minutes, and their takes about 10 sec....
I really hope I could reach some descent performance. I would appreciate some shared experiences.
Thank a lot in advance,
Regards,
Christophe.
Nota: thank you for the automatic migration of the meta model when adding features and tables like Teneo/Hibernate does, this is just great 
|
|
|
Current Time: Mon May 20 05:06:27 EDT 2013
Powered by FUDForum. Page generated in 0.02141 seconds
|
] 
Search
Help
Register
Login
Home
