In item master we can insert one image, but I want to add another 5 images to this (all together 6 item images). What is the best method of storing a image.
1. Keeping it in a blob field.
2. Saving to a folder and keep a link.
What is the best way of doing it? Are there any other methods available?
*This post is locked for comments
Hi,
I agree and recommend blob field and store the image in database which more secure and easily accessible.
Hi Dushan,
My suggestion could be:
1. Create a new table and keep the image file in BLOB
2. You can use the concept of "Implementation of surrogate keys using AutoIncrement pattern" for new table.
3. [Optional] You can save this new table in separate data file i.e. concept of multiple NDF file.
Thanks,
Manish
Hi Dushan,
My vote for saving images in blob fields. By doing this:
- Use NAV standard way to handle images, including read, write, report, transfer fields, ... (Jonathan mentioned).
- No need to manage and backup file server.
- Links between NAV data and file names are sometimes become dummy.
- Reading performance in NAV is not an issue unless blob fields are retrieving by CALCFIELDS (Tharanga mentioned).
- For storage, there are some techniques of SQL you can use such as shrink database, files, backup with compression ... for your database management.
Best way is to store your images in a NAV database.
It is safe and very easy to retrieve from the DB as Jonathan said.
About the DB size, yes it will be a problem with the DB size but SQL can easily handle this, if you properly manage the design. However you will definitely face performance issue with the time.
As a example if you save all these images in item table then at the time of you search in the item table, system will get slow.
Instead of doing that save all these images in a separate table and have a link to a item table.
By doing that you will be able to minimize the performance issue.
hi
yes, that could be a performance problem. storing the images in the sql server is not a problem, sql server are strong enough. problem is reading the images at runtime. always, when a record is loaded in nav, the image in the blob field is also loaded. so the useability of pages and reports slow down.
for a solution follow:
Storing images in DB is easy. Will it affect the DB size ? Because they have around 12000 items and 6 images for each item. All together 72000 images and still growing.
My worry is about database size and will it slow down NAV ?
hi
standard nav way (and also the simpler way) is storing them in blob fields.
your second idea will maybe also work: storing the images in a folder on the server. for usage it would be necessary to download them from server to client at runtime.
msdn.microsoft.com/.../dd301099.aspx
for reports: it's also possible the embed images in the report.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (