在添加数据网格期间编辑图像?和大型数据库有关. [英] Edit image during addition to data grid? And large database concerns.

问题描述

嘿，

我当前正在将图像添加到数据网格中.它们来自2个不同的，相对较高的rez相机，它们为我提供了.jpg〜1.5mb的图像.我想在添加它们的过程中使用C#代码调整它们的大小，以使其标准化并减小它们的大小.

I'm currently adding images to a datagrid. They are coming from 2 different, fairly high rez cameras giving me .jpg ~1.5mb images. I'd like to resize them in C# code during their addition, to standardise them and get their size down a bit.

该项目仍处于起步阶段，但我正在查看数据库完全启动并运行时每天向数据库中添加20-40张图像.每周仅图像上的数据量约为315 mb.我不是数据库/SQL专业人士，但这确实使我担心.将要 随着时间的推移会降低性能或对电灯应用产生负面影响?

The project is still in it's infancy, but I'm looking at the addition of 20-40 images per day, to the database when it is fully up and running. That's about ~315 mb of data per week on images alone. I'm no database/sql pro, but this does concern me. Will this degrade performance over time or negatively impact the lightswitch application?

如果到目前为止一切都还不错，那么该应用程序将在未来十年中使用，因此到2021年至少约为160gb.这是一个问题吗?

If all continues to go as well as it has been so far, the application will be in use for the next decade, so thats around 160gb at the very least by 2021. Is this an issue?

推荐答案

我不会争论您是否应该在数据库中放置图像.如果您决定不将图像放入数据库中，而是将其存储在服务器硬盘上，那么以下一些免费代码可能会有所帮助:

I wont argue if you should or should not put images in the database. If you decide NOT to put images in the database and instead store them on the server hard drive, here is some free code that you may find helpful:

您可以更改代码，以在上传图像后调整图像大小，并自动创建缩略图".版本，以便在数据网格中最佳显示.

You can alter the code to resize the images after they are uploaded and to automatically create "thumbnail" versions for optimal display in datagrids.

这篇关于在添加数据网格期间编辑图像?和大型数据库有关.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！