> > Is it a good idea to store images in an access db. > > Or should I rather just store the file path to the > > image?
> I have an Access db that has 751 jpeg's stored as > Image. The db is over 50Mb. > > I am not sure at what point access to the data will > suffer. For my app, the db can grow without > restriction. If it begins to suffer, I'll have to > re-engineer it to store the images externally. We try to avoid storing data in a database which cannot be included in a WHERE clause in a query. In other words, if you can't search using the data, it doesn't belong in a database. When you are using something like MS Access, this is especially true since the maximum MDB file size is 1GB (or 2GB depending on the version). If you store the image files in the file system and store the file name and path in the database, it will dramatically increase the maximum size your database can grow before you hit the wall. Glenn Lawler ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
