D
diegocan
Guest
Hi Gus, I removed the index because I was reproducing the problem. The database I was using when I encountered this did not have an index on the foreign field as the table was small only about a dozen records. When interfacing rollbase to a customer's database it may not be possible to introduce schema changes to conform with rollbase (if this is in fact is a requirement by rollbase, i.e. to have an index on a foreign field). Having said this for performance reasons you would probably alway want the foreign keys to be indexed. Hope this makes sense. Thanks, Diego.
Continue reading...
Continue reading...