Hi, can someone share expirience with performance limits of ObjectDB especialy when quering tables with large records sets.
Our issue is with tables with 100.000+ records. Everything was OK when we had few thousand records.
We have a simple SELECT statement which selects from a table with 100.000+ records by UserID atribute, tables have from 5 to 20 atributes. Usualy the results range from few hundred to few thousand records. This query takes up to 12 seconds.
Is this normal, what when we will have few milion records, how to handle this.
Everything is set to lazy loading, we tried indexing the table and it doesnt help much.
In this case ObjectDB is used similar to a relational database. I have seen a similar query on a relation database with few milion records working in a sub second range.