Look into reducing the "text" columns to a varchar if possible.
Use a stored procedure instead of passing raw sql to the server.
Index on the fields in your where clause. (Check the execution plan)

Eric Stephani


>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 ?