General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi,
> I am developing multiuser application. I have a query which need to join 3 tables through network. Could I know, which way of SQL coding is faster?
>
>1. Join 3 tables in ONE SQL Statement
>
>2. Firstly, join 1st and 2nd table and then join the 2nd with the 3rd table.
>
>
>Thank you
The answer depends on how big the tables are and the types of joins involved. Gnerally, three table joins will not cause problems. I think VFP supports up to seven table joins. In my experience, however, I have found that eanything over three tables tends to impact performance. The best thing to do is test each scenario and decide for yourself.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only