Subject Re: [IBO] Views or Lookups
Author Artur Anjos
I don't have a 'yes/no' answer to you. I use bougth ways, acording to circunstances... If your Lookup Table is small, you can read it all and keep it in memory. If not (such as Zip Codes), I prefer to use 'views'.

You must think in the difference between the two: with views, the server do all the 'lookup' you need, and give you all the data in a go. It's fast, with minor communication overhead. With Lookups, the client do the main job.


----- Original Message -----
From: zifnabbe@...
Sent: Sunday, December 02, 2001 3:13 PM
Subject: [IBO] Views or Lookups

Is it better to make views (which join a view tables), or make use of
DBLookup fields?

[Non-text portions of this message have been removed]