I have 10 Million of records in a table in MySQL database,should i go for a REALTIME index or a PLAIN index
Which is best option…?
Is there any workaround for the same…?
A Realtime index would provide you with more features such as replication, backups, and the ability to insert data in real-time. On the other hand, using a plain index would allow you to sync your data from MySQL more quickly, as you wouldn’t need to create a script to read from MySQL and write to Manticore. Ultimately, the decision of which option is best for you depends on your specific needs and preferences.
You can have both worlds. First, use indexer for plain index: “indexer myplainindex --rotate” and then replace it with rt index with an SQL command: “ATTACH INDEX myplainindex TO RTINDEX myrtindex WITH TRUNCATE”. From now on you are on rt index.