Forum Moderators: open
where do you store large amounts of text? in DB or just the server?
what if the size exceeds NVARCHAR(4000)?!
what do you think?
actually its the promise of full text search that keeps me still intrested in storing it on DB.
However, there are other things, like how it would effect performance of DB? what if the path between webserver and Db incrases? how diffcult it would be to BACKUP the DB?
PS: DB space is more expensive too!
It should have little affect on the performance of the database as the NTEXT contents are stored seperately from the data rows. Conversely, storing the text as NVARCHAR(4000) would slow down data retreival as fewer rows would fit on a data page.
Backing up the database would be the same.
