Hi Glenn, In the future, please create a new email instead of replying to a threaded one. Your question ended up in the middle of a long discussion about Drupal and GPL. Emails that are threaded are tagged so your email client can tell which emails relate. When you replied, your email got tagged making it appear being part of the GPL discussion. Creating a new (untagged) email, your email will be considered to be a new thread and will end up at the "root" level. Thank you, Jakob Persson Glenn Wybo wrote:
Ok, thanks,
well, was considering if it would be necessary to use BLOB's to upload the images to a database between our server and the compunter of the client. The thing is that my boss wants to upload many images (corresponding with the company of the customer) to another database when the customer logs in on the website. This database will only be used for storing the images and the corresponding data. The only reason for this is to improve speed. When the customer selects a couple of images, it may only be a matter of milliseconds to select the images (and the data that corresponds with it) in the database and upload it to the screen of the user.
thanks for the advice,
Glenn
Date: Fri, 7 Sep 2007 10:20:27 -0500 From: mark.m.fredrickson@gmail.com To: development@drupal.org; nevets@mailbag.com Subject: Re: [development] table vs tables
The "obvious" way to break up the table would be to use 1000 a smaller tables, but too many tables can also cause a problem.
You might also look at table partitioning:
http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html
Basically, it splits one tall table into many, smaller chunks that look and behave like a single table. So you don't have to change your queries but you could possibly get some performance benefits by not having to scan or load as much of a table into memory.
I'm not a DBA, so I don't know how this really ends up working in practice, but that's the theory at least.
-Mark
------------------------------------------------------------------------ Bekijk de beste Live Earth concerten op MSN 07/07/07 Live Earth <http://liveearth.be.msn.com/>