>Hi guys,
>
>I've got a Foxpro database that I'm going to pull information from and put into a single Oracle table. The Oracle computer is remote to the Foxpro computer. I need to just confirm one thing and ask one thing, please.
>
>Which is faster in general -- remote views or SQLCONNECT and SQLEXEC commands? I'm at a point where I could set up my import into Oracle in either fashion, depending on which is more efficient.
>
>No matter which way I jump, either with a remote view or with a SQLConnect, I'm going to need a DSN which means that the Oracle network client is going to have to be loaded on my Foxpro machine, right?
>
>Thanks in advance for the help!
If the data is going in one direction - VFP to Oracle - then either will perform okay. I have a little comparison form that I use for demos of the two methods, and no matter how many times I test it, the differences are statistically insignificant. (This is going against SQL Server, not Oracle, BTW). However, SPT (SQL pass-through) gives you much more control, especially if you have to do any kind of data transformation.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
