You're welcome. Try to do the import without chunks first to see if you're happy with the performance and memory consumption. I guess it's a little simpler.
If you don't care about people being able to copy all the images from the directory, I guess it's fine to store them outside of the db and just store the image names. If you have a web app it also works better with the images outside the db so the browser can detect when the same image is used more than once (based on the URL) and just reuse the same instance. My client is slightly paranoid, so all images were watermarked and stored in the db, with the application's clipboard disabled for certain users. When in doubt, create a small sample, benchmark it and then you'll know ;-) On Friday, June 15, 2012 1:01:09 AM UTC+2, vicenrico wrote: > > Thanks for the code. I think is more or less what I needed. Tomorrow I > will begin with the test with your code and I expect they will be fine. > I've had a look into the it, and I'm glad. There are a lot of things that I > didn't know (I'm a software developer but not very good with db's :-( ), > so I will do a deep scanning of this code, haha.... > Thanks again. > > The only part I can't use is , as you said, GUI, because I'm using SWT , > but it's very easy to do the change. > > I only have a doubt: when you say to "do the import by using chunks", what > does it mean? I'm planning to have as maximum 10000 movies or so, so I > think I can import complete database (select * from movies) in one pass. Do > you recommend me that? or should I import chunks of 1000 movies to not > spend memory? > > And , of course, the million bucks question: To have the images saved > (100-200 kbs per image) , do you recommend me to save path into database, > or it's better to save this small images into database?. Currently I only > save the paths, and do the loading on demand. > > Sorry for my bad english, I'm spanish....I will try to improve it :-D > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/u3e1yxZRyuIJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
