Nuno wrote: > Yeah, a religious question, i know, but what's recomended?... > > I have a small site that may have some images for some products. Said > products may also have descriptions. I have other small sites and one > where i'd like to manipulate large texts (say around 5 paragraphs... > ~5000 characters). > > What's recomended: to store strings that are the /path/to/textfile or > /to/image.jpg? Or to store the image file in the database? the text > file in the database? Which datatypes to use? >
This is a very good question, and you must ask it every time you consider blobbing. It turns out that all things being equal, there is a size at which blobs work better, and over which the file system is appropriate. Here is a discussion paper: http://research.microsoft.com/apps/pubs/default.aspx?id=64525 This paper was written some time ago (2006), and technology moves, CPUs, networks and disk drives get faster, memory larger, and some operating systems become more bloated. As various aspects which affect this high water rule of thumb change, so must your confidence in the actual high water mark number. Because you are using (?) SQLite, a number of variables are different than accessing a client/server database, but as it seems that you are going to squeeze the data through a web server, other bottlenecks may apply. Experimentation is recommended, but the real qualifier will come at saturation point. HTH, Rob Sciuk _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
