TransferDatabase or MakeTable

[Rob.Mills]

I have an application which contains several reference tables. I've set it up where when the user opens the application all the reference tables are copied over so that they're local. I've been doing this using make-table queries and then creating an index on them.

What I'm wondering is would it work faster or better to use transferdatabase command to simply copy the table?

 

[FoFa]

If they are reference tables, what advantage are you gaining by coping them locally? Typically reference tables are rather small (OK not always, but usually). I would think a link would be suffciant?

 

[Rob.Mills]

Some are big, some small. But I've always made a habit of copying them locally because I've found a big improvement in forms loading when several people are connected.