I just discovered a major difference in performance when using local view in a multiuser network environment from a readwrite or readonly database.

A particular view takes about 1.4 seconds to open (NODATA). This is caused by the massive view definition that has to read from the database. Since the database is not readonly, the view definition is read entirely from the database each time it is loaded.

After I marked the database readonly the same view was loaded in 0.20 seconds. It makes sense that it should be faster since the database can be cached in the workstation, though I was stunned in the performance difference. This made me wondering why I should not mark my database readonly because in most of my applications the database definition never changes since for updates I place a new database and append the table data from the old one.

My question is, has someone found problems or bugs when using readonly databases ?

Walter,