2005/8/20, Kane Wilson <[EMAIL PROTECTED]>: > hi Friends, > > I have a WAP portal which is running based on mysql database. That's meant > that contents has been stored in the data base. > wallpapers , themes, ringtones, games .......etc data type as BLOB. upto now > now problems with the content retrieving. WAP site hosted in REDHAT Linux BOX. > I will leave my question by point form , > 1. http://www.zend.com/zend/trick/tricks-sept-2001.php according to info of > this link , it says there is performance issue when using BLOB for data > storing and retriving in mysql and he has recomended some statndard file > sharing / accessing methods to use . for instance samba or NFS - in linux. > is this happening in mysql ? does it has a solution in mysql ? what could be > the best way to use mysql to store / retrive my contents via the wap site ? > I'm using mysql bcause , keeping data in a database is very easy to do a site > search , rather than keeping contents in folders .
The approach generally used is to store in your DB, information concerning your file (its type : ringtones, themes, wallpaper), its size, keywords and everything you find useful, and then keep the file on disk (and having its path sotred in the DB as well). You move all load from serving the files (ringtones, wallpaper) to the FS which does it very well _and_ can be cached by proxies, browser (less load for the server). So you an still do a site search since you keep all the useful information in your DB, but raw data stay on disk. For example if you need to send a ringtone which is in your DB, the browsersend the request, Apache receive it, load PHP/Perl, which then connect to the DB... If the file is on disk, you remove the last 2 operations which willmakethe whole operation faster. -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
