Formula Fill Timing Issue

[Pete]

Yikes, so much for a fast Ram based database.  Is this just an inherent
weakness or is there an alternative, such as perhaps sorting both databases
in ID order so they line up properly and then doing a copy and paste from
the second database field to the added field in the first database?

Ken was able to resolve his issue by going back to a relational database and
doing a simple join.  I talked him into using Panorama because it was so
fast and could manipulate data so easily.  I hope I don't have to eat crow.
I am still stuck back on the PC version 4.02, so I don't know what lies
ahead yet in that fancy 5.5 version.

Pete Schuder

------Original Message-----
-From: qna-bounces at provue.com [mailto:qna-bounces at provue.com] On Behalf Of
-Chris Watts
-Sent: Saturday, February 09, 2008 1:12 PM
-To: Panorama Questions & Answers (Discussion)
-Subject: Re: Formula Fill Timing Issue
-
-And if it's an Enterprise database, pack a toothbrush, because it will
-take about 11 hours to complete the formulafill!
-
-cw
-
-
-On Feb 9, 2008, at 8:30 AM, David Thompson wrote:
-
->> 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.
->
-> In Ken's case, there were 200,000 records in each
-> database, according to information provided in a
-> later email. Over the course of the FormulaFill,
-> the lookups( would be doing a total of
-> 20,000,000,000 comparisons between the key value
-> and the key field. (The average lookup will find
-> the record it's looking for after looking through
-> half the records, and there will be 200,000
-> lookups.) That's going to take an inordinately
-> long time no matter where the key field is
-> located. With databases that size, you want to be
-> looking for any alternative to the
-> lookup/formulafill combination that you can come
-> up with.
->
-> Dave
-> _______________________________________________
-> Qna mailing list
-> Qna at provue.com
-> http://provue.com/mailman/listinfo/qna
-
-
-_______________________________________________
-Qna mailing list
-Qna at provue.com
-http://provue.com/mailman/listinfo/qna