There is not a set rule that defines when SQL CE should be used; it depends on the amount of data, data relationships, query types, update frequency, etc.