Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-21 : 09:38:06
|
| Navinderjit Singh writes "I am maintainig one portal. Its basically ASP-SQL Server combination, both on the same machine.Now in one of the tables in the database there are some columns whose datatype is 'Text', these columns are expected to have data nearly between 5 to 5000 characters and that table is being assessed from one of the ASP page (this page receives 90% of the total hits on our portal), this page uses stored procedure having single sql-query 'Select * from <Table Name>' query.Now When there are many simultaneous hits to this page it become to bulky and stops responding.I want to ask you my doubts on this problems ..(Hardware solution are out of scope/pocket)1) Is changing of 'Text' to 'Varchar' datatype helps in any way andperformance in overall scenario?2) If yes, then will it also improves retrieving data , which was present beforeupdating datatype from 'Text' to 'Varchar' from these tables?Also if you have some suggestions on imroving performance on database front please do let me know.regards,Navinderjit Singh" |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-02-21 : 09:52:03
|
| Converting text fields to varchar will certainly improve performance. Unlike varchar fields, the data for text fields aren't stored in the table. Instead, a text column contains a pointer to the data outside of the table.You can also use several string functions for varchar that you couldn't use for text. |
 |
|
|
jackstow
Posting Yak Master
160 Posts |
Posted - 2002-02-21 : 12:24:30
|
| If the data doesn't change constantly why not try an ASP.NET front end for it and use the caching features of .NET so you don't have to recreate the page from the database everytime it gets a hit..Jack |
|
|
|
|
|
|
'Text' to 'Varchar' conversion. Will it improve performance?