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-03-13 : 18:25:21
|
| Lev Kutamonov writes "Hello!I have site with large DataBase.There i have some applications.There are many texts in this application.Is this good idea save all texts data in one table (table(id int, text ntext, page int)) for all site and just save id of inserted text in application table?If this table may go up to 500 thousands records or more,the join opperations will take much time for query?So, may be part the table for several tables, table for each application, but one table more convenient.Any tips?Thank you!" |
|
|
Jay99
468 Posts |
Posted - 2002-03-14 : 08:56:04
|
| I would say no. Remember how a ntext is implemented. Only a VARBINARY (the address of the first page of the ntext field located somewhere else in the file) is stored on the table.Jay |
 |
|
|
jackstow
Posting Yak Master
160 Posts |
Posted - 2002-03-14 : 09:55:44
|
| Maybe, but do avoid ntext. Would be better if you had another table with your text split up. Perhaps;***TEXT TABLE***paragraph_id intparagraph nvarchar(4000)sequence int.. and then split your text over several paragraph_id's. |
|
|
|
|
|
|
Saving text data in one table for all site.