Formula Fill Timing Issue

[Ken Doucet]

Mark,thanks for the tip, I haven't moved fields around yet but will keep
this in mind.
As I was pressed for time I did a join in another database that was far
quicker and then brought the file back into Panorama.

Ken


Message: 4
Date: Sat, 9 Feb 2008 10:59:19 -0500
From: Mark Terry <mark at abernackie.com>
Subject: Re: Formula Fill Timing Issue
To: "Panorama Questions & Answers \(Discussion\)" <qna at provue.com>
Message-ID: <B095B6EF-6641-4093-89C5-0869BD30137C at abernackie.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes


On Feb 6, 2008, at 10:50 AM, Ken Doucet wrote:

> I am trying to add fields from one database to another using formula
> fill
> lookup - syntax generated by system is:
> lookup("CMEMAILV",RECID,RECID,"Valid","",0)  but everytime I run
> this on a
> 200k table (on an intel macbook pro) it seems to hang and I have
> forced quit
> after 30 minutes (I have no frame of reference for how long this
> should
> take). When I assign a new value within the database it takes
> seconds but
> this lookup is causing me some grief.
>
> Basically, the goal is to expand my 200k table to include the
> suggested
> corrections from the mailing house so end result would be that I have
> ORIGINALCITY and REVISEDCITY etc in one database so I can verify
> potential
> impact on end user database before I apply them. I was hoping there
> was an
> equivalent to a table join that would consolidate into 1 table.
>
> Say Table1 has 12 fields including a RECID field
>    Table2 has 15 fields including a RECID field
>
> Goal Table 1 has it's 12 fields plus 10 of the fields from Table 2.
>
> Appreciate any suggestions

The further the data column is from the key column, and the further
either of them are from the first column, the longer the lookup( time.
Since it's so easy to move field positions around in the Design Sheet
(Cmd-up or -dn), you might consider making them cols 1&2, at least for
your lookups.

M