odbc import speed difference between startup/import scripts?

[Sefu]

Dear All,

My yesterday's question (answered, thank you), one concerning drop-down lists on fields imported from an external odbc source, brought up another for which I can't seem to find any answer in any FMpro guidebook or tutorial.

I notice an enormous difference in download/display speed between fetching odbc data with fmPro's 'native' query and when using scripts: in using the 'default' layout just after managing my odbc source, it manages to load data and switch between form, list and table views without any lag at all; yet should I perform a lookup using a script, the download takes ages. Does anyone have any explanation for this difference, and is there any way around it?

Thanks in advance,

Sefu.