| Ciantic | cornernote_, what? I don't want to pipe it to mysql, I want the SQL |
| cornernote_ | oh, i see, you just want that format you dont get the fields when you dump ? |
| Ciantic | actually ... (fields) VALUES(...) |
| cornernote_ | just the values |
| Ciantic | cornernote_, yup, and the worst is that all of the rows are in same INSERT |
| cornernote_ | i think there are format options, but i dont know off the top of my head, sorry |
| Ciantic | by default it comes in: INSERT INTO ... (row1),(row2),... which is not what I wanted |
| cornernote_ | you could write a script in perl or php to do it if worst came to worst |
| Ciantic | damned! mysql used to print 'em in that one INSERT per row format earlier |
| kimseong | Ciantic: becasue multi row is faster, so mysql change the --opt to be default |
| Ciantic | kimseong, what? |
| Freaky | --skip-opt |
| AndyGore | has anybody used memcached ? |
| Ciantic | oh right, I'll try that, thanks |
| thefirstdude | is it a good idea to store files in mysql, versus on disk? |
| thumbs | blob errm. |
| thefirstdude | cause I'm thinking I wouldn't spend time opening and closing the file |
| thumbs | storing blob in sql is rarely a good idea. |
| thefirstdude | how come? |
| thumbs | it increases the amount of data to return from a query dramatically |
| thefirstdude | I also wouldn't need to worry about having a "file directory" etc. |
| thumbs | in some cases, that increase can cause timeouts, and other delays |
| thefirstdude | will that hurt somebody? |
| thumbs | the speed of your application will suffer. |
| thefirstdude | yeh... |
| Freaky | depends how big your blobs are |
| thefirstdude | I'm thinking videos ;) |
| Freaky | err ;) |
| thumbs | then I would definitely say NO. |
| Freaky | "You're fired" ;) |
| d-media | More than one FULLTEXT key was created for column `Item_Name` this is not a good message is it LOL? |
| action | Freaky calls security |
| Freaky | calls security |
| thefirstdude | good thing I haven't said my name |
| Freaky | Chad Hurley? ;) |
| seekwill | There are a few cases where storing large files in a DB structure will work. It's just usually better to use the "file database" |
| thefirstdude | lol, now that I think about it I've been called Adam alot! THE file database? what's that? |