+ Reply to Thread
Results 1 to 2 of 2

Merge as new vs inline merge PQ

  1. #1
    Registered User
    Join Date
    10-18-2019
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    Office 365
    Posts
    7

    Merge as new vs inline merge PQ

    As I am getting the hang of PQ and PP, I'm starting to look at optimizing queries since they're now all over the place and seem to have quite some loading times.

    tl;dr is basically, are there pro's and cons in using inline merges vs 'new merges'?

    Small example;
    External Table 1 is inline merged on External Table 2;
    External Table 1 is inline merged on Local Table 3;
    Local Table 3 is joined on External Table 2;

    How often is External Table 1 retrieved? One time, after which its data is merged 2 times? Or it is retrieved at the initial connection, and each inline merge at the 2 other queries?

    Would it be better to load External Table 1, External Table 2, and Local Table 3, and merge as new, which then is loaded into data model? Or, is there really no difference, and is data loaded only one time anyway?

    Thanks in advance for your time.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Merge as new vs inline merge PQ

    Not a direct answer, but what I tend to do these days is load as much as I can to connection only, then merge and load only what is absolutely necessary.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 11-15-2018, 10:54 PM
  2. Replies: 0
    Last Post: 06-24-2015, 02:34 AM
  3. Email merge from excel merge file using pre-saved word template
    By d_max_c in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2014, 12:33 PM
  4. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  5. Email Merge with variable merge records break by client level
    By sss047 in forum Word Formatting & General
    Replies: 0
    Last Post: 04-15-2011, 04:25 AM
  6. Merge 2 Worksheets (Same concept as RegEdit Merge or Outlook Vcard)
    By stevedes7 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-20-2009, 11:17 PM
  7. Replies: 0
    Last Post: 04-21-2006, 03:40 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1