http://forum.space4j.org/posts/list/1.page JForum - http://www.jforum.net In my application,there will be many indexes to be created,and some indexes should be created dynamically,is there any question?
And how should I can calculate the space of indexes?

thanks

--Ford

]]> http://forum.space4j.org/posts/preList/10/13.page http://forum.space4j.org/posts/preList/10/13.page GMT In my application,there will be many indexes to be created,and some indexes should be created dynamically,is there any question?
[/quote]

No problem at all. Indexes can be created dynamic. Just like with any relational database, the indexation process can take long if your dataset is large. I would not worry for anything < 500k.

If you are indexing a huge dataset, it is better to do it offline, with your system off, to avoid write locks. Same problem with any relational database.

[quote]
And how should I can calculate the space of indexes?
[/quote]

Not easily. Java will not easily tell you the ammount of memory an object is taking. There are hacks to do this. Google it and if you get a good solution please share with me.]]> http://forum.space4j.org/posts/preList/10/16.page http://forum.space4j.org/posts/preList/10/16.page GMT