>Hello Sergey,
>
>Yes, i was asking about it.
>Also, This relationships work faster than views, do you think so?
>
>Thanks,
>Juan Carlos
Juan Carlos,
That depends on what you are doing with the data. A relation takes milliseconds to set, while a view may take longer to get the records. However, once done the view may function quite faster than the relationship while processing those records.
Also, a view can make your code considerably simpler as it deals with a single work area instead of multiple work areas, while a relationship has to deal with the physical storage of the data in multiple tables.
Views are also more easily upsized to working with data that is not stored in VFP tables, while the relationships are limited to only VFP tables.
So, as you can see, there are many issues that influence whether it would be more prudent to use a relationship or a view to process the data besides the time it takes to process one single command (SET RELATION or SELECT).