General information
Forum:
Microsoft SQL Server
Category:
Database management
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 ?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only