Home » forums » General » Troubleshooting

Multiple index from the same database

Submitted by prkumar on Fri, 2010-01-15 13:44.Troubleshooting

I want to create multiple indexes. The columns for both the indexes are same. Each index fetches data from the same database but different schemas.
I could have configured a single index with a union query from both the schemas, but I just want to avoid this.
Your document says that I should not configure two indexes for the same databse else the increamental indexing will run into each other and later job will abort the previous indexing job.
Is it still a limitation?
What if I use two different users in the the configured datasource for each index?
What is the best solution?

login or register to post comments | previous forum topic | next forum topic

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
No conflicts as far as I remember
Submitted by will on Fri, 2010-01-15 15:32.

DBSight is just read only. So it's unlikely the incremental indexing would run into each other.

Of course you may want to schedule the indexing during different times to avoid over-burdening the database.

Please let me know where you saw the "run into each other" document and I can clarify it more.

login or register to post comments
Multiple index process from the same database
Submitted by prkumar on Sun, 2010-01-17 19:38.

In the following page :
http://wiki.dbsight.com/index.php?title=Search_Multiple_Data_Sources
It says :
But make sure you don't specify 2 indexing for the same database at any moment. Otherwise, the latter indexing process will stop the previous one.

Does it mean that you should not have more than one indexing process with the same database? Please clarify.

login or register to post comments
Thanks! A better explanation.
Submitted by will on Sun, 2010-01-17 22:26.

Oh. Thanks! It's misleading.

It just meant that if the first indexing job is not finished, but another indexing job is scheduled and started, the latter indexing process will stop the previous indexing process.

login or register to post comments