Plain index OR Realtime index for huge data - 10 Million records

General Discussions - English
1

Hi there,
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…?

2

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.

1 Like
3

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.