>Hi all,
>I have a SQL table which contains many fields including
>about 5 Text (Memo) fields and this make the table is rather
>in record size. Thus occur busy and timeout problem oftenly
>when SQL Update/Insert records to this SQL table within VFP
>using this command : SQLEXEC(conn1, "update .......")
>How to correct it ?
How are you passing the changes to the table? That has a big impact on the speed.
You may also want to check the indexes on the table. You may be able to increase performance by changing the indexes to make the query you use to update.
Lastly you can also change the timeout setting via SQLSETPROP.
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.
