Shape vs. Join

Results 1 to 2 of 2

Thread: Shape vs. Join

  1. #1
    Join Date
    Dec 1969

    Default Shape vs. Join

    I have a relational database with several tables in MS Access. Table 1 (say) is a one to many relationship with Tables 2,3, and 4 (each having some data related to records in Table 1).<BR><BR>To create recordsets and write new records, which is more efficient? Shape or Join? Any insight?

  2. #2
    Join Date
    Dec 1969

    Default RE: Shape vs. Join

    They say Shape works faster then query(e.g.join)on your page,do not ask why,but precompiled query should work even more faster becouse it is already precompiled sql statment,it is just waiting for your call.When you use e.g.Shape or Join these queries will be compiled first in db and then only used...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts