Quote:How does internal xlookups in Sesame compares to xlookups in Q&A as far as speed is concerned? With indexed fields in Q&A, we, at times, have problems with corruption. Is that the reason, why Sesame does not have indexed fields?
The speed depends on a lot of factors. In a XLookup the speed is dependent on the field types, the total size of the application, and the overhead to data ratio. If you have two Sesame applications that are about the same total size, but one has fewer fields or records and more data per field or record - it will go faster.
Comparing Sesame to Q&A for speed of XLookup is dependent on the characteristics of the applications involved. On some, Sesame will go faster, on others Q&A will go faster - based on the arrangement, type, and size of the data.
If you were to do head to head timing tests, you will need a very wide variety of applications and then average the results.
There are several reasons we do not use indexes, corruption is one of them. The primary reason is to keep things as simple and homogeneous as possible. That way, if we discover that we need to optimize any particular operation, there isn't a specialized optimization technique already in place that might be in the way or too inflexible. Its better to keep things very simple and apply complexity where we need it - as the need is proven.