Home > Software engineering >  A lot of people said the database insert images is bad, took advantage of the opportunity of come of
A lot of people said the database insert images is bad, took advantage of the opportunity of come of

Time:10-07

Database file 50 m, picture number 1500, each image size between 200 KB to 300 KB, due to the bug problem like statements, to switch to instr bypasses the Japanese query error, feeling didn't go slow, the computer is a pentium II + 32 MB + win98 operating system





Now is it needed to insert about 2000 pictures, I do not know how much ACCESS and expand the space, my idea is to put 3000 images first, if you don't feel any questions, I even icon added, icon is about more than 6000, is the NDS game icon,

CodePudding user response:

computer is pentium II + 32 MB + win98 operating system ???????

The building Lord, you NB...

CodePudding user response:

Bullshit, you this is the system of Windows 2000 +,

CodePudding user response:

Yes, this should be a Win2K or higher "is a classic color scheme",

Windows 98, the system default color scheme, the scroll bar, the label background, "three-dimensional object" such as the surface of the button color is & amp; HC0C0C0,
The original poster of this picture, the scroll bar, the label background, the background of the form, are & amp; HC8D0D4, with Win2K or higher version of the "classic color scheme is consistent,"

CodePudding user response:

We focus on migration, I just in order to explore the limits of the access is using a can connect to the Internet computer cut a figure, and I have a similar application load 3000 + a game on the PII computer are two seconds,

















My old friends in the honeycomb briquet, also use a win98 don't need to disturb the central,

CodePudding user response:

CodePudding user response:

Thousands of pictures is not much, you imagine CSDN, every day tens of thousands of registered users, upload pictures of hundreds of thousands of copies, the number of images are displayed, hundreds of millions of times,

CodePudding user response:


Fast and slow are relative,

The point of application design is fully meet the requirements, if under certain conditions, do you think can meet the need, is not can't insert the picture database,

I once worked in a few years ago a application, image bigger photos (usually), just save the picture in a specific folder, then the machine memory is also small, photos to the database, query caused a lot of disk exchange, quite slow,

In addition, the written application to considering the user may use the worst machine environment, if a program is only own machine to use, of course, is much more simple,

CodePudding user response:

The building Lord tried not remote, speaking, reading and writing?
If the database is remote, then the query, want to put all the results of the query to download to a local can be returned to the caller after
So some people think the database query image will feel slow

This is not as simple as the browser view picture, browser based on socket communication, can download while handling
The database is all back again after the download

CodePudding user response:

Database access efficiency was higher than the file system, just have the database can not directly see, needs the corresponding software

CodePudding user response:

Images to the database, less cases and users as a single user ACCESS, even less single cases such as general ok.

Said have performance problems, mainly is the number, and the problem under the multiple users and network usage, if you met, there will be no this post.

Only as a stand-alone single-user hard disk IO is usually enough, not too much as long as the pictures.

CodePudding user response:

I also put pictures in the database now, before is to intercept figure export of BMP file again flow to the database, find the remote read a bit slower, then compressed into JPG, deposit and export again, can be several times as fast

CodePudding user response:

The original poster can post the code to readers, also let my learning how to learn

CodePudding user response:

The local store, quantity is not big, and the traffic is not high, plus index, shouldn't be slowly,

But tens of thousands of article, plus traffic large, certainly will be very card, not give it a try,
  • Related