You can speed up text columns in MS SQL also :) MS SQL Server supports a feature which stores a specific amount of characters in the text column, and the rest is stored in pointers. This can result in a dramatic improved performance, but this depends on the amount of text you have.
When you look at the design view, you also see the size of the text column changed to 256, the rest is saved in the background to pointers. With this option I saved hundreds of milliseconds on select statements on larger datasets. Example: EXEC sp_tableoption 'Content', 'text in row', 'ON' GO UPDATE Content SET Data = C.Data, DataStripped = C.DataStripped FROM Content C GO Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184093 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
