Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO] DBStore annotation to index columns
[CDO] DBStore annotation to index columns [message #1113009] Fri, 20 September 2013 10:06 Go to next message
Ashish Shinde is currently offline Ashish Shinde
Messages: 4
Registered: August 2013
Junior Member
We are trying to use DB Store for our application. We would like to add additional indexs on created tables to speed up a lot of our queries.

DBAnnotation looked like the way this could be achieved, however we could not find an annotation for index creation.

Regards,
Ashish
Re: [CDO] DBStore annotation to index columns [message #1113103 is a reply to message #1113009] Fri, 20 September 2013 12:46 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5252
Registered: July 2009
Senior Member
Am 20.09.2013 17:28, schrieb Ashish Shinde:
> We are trying to use DB Store for our application. We would like to add additional indexs on created tables to speed
> up a lot of our queries.
> DBAnnotation looked like the way this could be achieved, however we could not find an annotation for index creation.
That's currently not supported but would probably make a nice contribution. Please submit an enhancement request. Please
note that I won't have time soon for this, so please consider to attach a patch ;-)

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: [CDO] DBStore annotation to index columns [message #1113476 is a reply to message #1113103] Sat, 21 September 2013 02:32 Go to previous message
Ashish Shinde is currently offline Ashish Shinde
Messages: 4
Registered: August 2013
Junior Member
Thanks Eike,

Have created an enhancement request here.

Will work on adding this feature.

Making a single column indexable looks simple enough even for a total EMF and CDO novice like me.

However will need a little help with the spec for multi column indexes and maybe even column constraints like UNIQUE.

[Updated on: Sat, 21 September 2013 02:36]

Report message to a moderator

Previous Topic:Writing values through commands
Next Topic:[CDO] asynchronous auditing to improve performance
Goto Forum:
  


Current Time: Mon Oct 07 08:11:36 EDT 2013

Powered by FUDForum. Page generated in 0.01998 seconds