CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> General -> Other

 Large amount of text in database?

Print topic Send  topic

Author Message
headhunter


Posts: 130
Posted: 01/21/2004, 12:55 AM

I was wondering if it is a good idea or not to store a large amount of text (html content) in the database (performance, ...).
I use PHP + MYSQL.
Any other suggestions?
It is also for use in a multi langual website.
View profile  Send private message
Edd


Posts: 547
Posted: 01/21/2004, 5:00 AM

headhunter

I have been advised for very busy sites it is NOT ADVISABLE to store things such as BLOB data or large strings in a database as the transmission between the Database and the Web server will slow it down.

You make the call - if it is high volume - NO. If it is low volume and it is easier - YES.

_________________
Accepting and instigating change are life's challenges.

http://www.syntech.com.au
View profile  Send private message
Steve_Ebbrell

Posts: 11
Posted: 02/09/2004, 7:54 PM

BLOB's are best in a seperate file, then if you call them only as required they do not slow down any iterations through the main data.
_________________
Ambition is the last refuge of the failure. - Oscar Wilde
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.