Mass Data on db
-
Hi I'll develop a website that people will post something formatted with HTML with some pictures. Which way is better to save these content (long HTML with several pictures)? Save them in db or save them on disk? Why? Thanks a lot.
-
Hi I'll develop a website that people will post something formatted with HTML with some pictures. Which way is better to save these content (long HTML with several pictures)? Save them in db or save them on disk? Why? Thanks a lot.
Alireza Loghmani wrote:
Which way is better to save these content (long HTML with several pictures)?
That depends on your needs, both have advantages and disadvantages. I listed some in the answer over here[^]. A website; how many space do you have on your ftp-account, and how many space is available in your database? If it's a very busy database-server (lots o' queries, lots o' records), I'd opt to save the files in the directory-structure. Otherwise, they'd go into the database. Especially with an online-host, where they might have separate backupplans for databases and normal files. There's an extra advantage to having them saved as files on the system; if the directory is accessibly from IIS, you could hotlink to that file from outside your server - without the need of adding any load to your databaseserver at all :)
I are Troll :suss:
-
Alireza Loghmani wrote:
Which way is better to save these content (long HTML with several pictures)?
That depends on your needs, both have advantages and disadvantages. I listed some in the answer over here[^]. A website; how many space do you have on your ftp-account, and how many space is available in your database? If it's a very busy database-server (lots o' queries, lots o' records), I'd opt to save the files in the directory-structure. Otherwise, they'd go into the database. Especially with an online-host, where they might have separate backupplans for databases and normal files. There's an extra advantage to having them saved as files on the system; if the directory is accessibly from IIS, you could hotlink to that file from outside your server - without the need of adding any load to your databaseserver at all :)
I are Troll :suss:
OK man, thanx. that's my answer.
-
OK man, thanx. that's my answer.
-
Hi I'll develop a website that people will post something formatted with HTML with some pictures. Which way is better to save these content (long HTML with several pictures)? Save them in db or save them on disk? Why? Thanks a lot.
Alireza Loghmani wrote:
Save them in db or save them on disk?
Isn't the DB on disk? :confused: I'd just stick it in the database; easier to backup, copy, etc. Plus, I'd live in fear of someone deleting or modifying the files.