ActiveAndroid icon indicating copy to clipboard operation
ActiveAndroid copied to clipboard

Adding indexes for colums

Open larsbard opened this issue 11 years ago • 2 comments

Hi. Thanks for a nice library. It has made my job a lot easier!

When implementing my database, I have a large data set to search through based on timestamps. This is slow, and it would be marvelous to use the SQLlite indexing support. http://www.sqlite.org/lang_createindex.html

For instance:

@Column(name = "TIMESTAMP")
@Index 
private long timestamp;

or:

@Column(name = "TIMESTAMP", index = true)
private long timestamp; 

Bestest regards Lars

larsbard avatar Sep 03 '13 07:09 larsbard

I’d prefer an table-annotation, because I’d like to create compound indexes.

vonloxley avatar Sep 03 '13 10:09 vonloxley

Can we close this because the PR has been merged... 5 years ago?

joshuapinter avatar Apr 12 '18 21:04 joshuapinter