Home > database >  Consult everybody is how to solve the problem of the performance of the system
Consult everybody is how to solve the problem of the performance of the system

Time:10-01

RT... You say casually

CodePudding user response:

The optimization of SQL statements, complex queries to the database as far as possible, with parameters of retrieve (), less images,

The image is still a little don't understand, some high configuration, the display images have a point card instead,
Suspected to be connected with the graphics driver

CodePudding user response:

Based on the database management system software and database of the main performance is in the interaction (any junk code) on
So the database table structure design, program interactive SQL statement that shows the key is to improve the performance of the system

CodePudding user response:

This topic is too fuzzy point,
Can only say that at the present stage, analyzing the specific issues

CodePudding user response:

Database design is good ~ ~

CodePudding user response:


Buy the new machine
PC can't use the server, the server can't change the mainframe...
Software and hardware to system integration:
Sometimes deliberately performance is low, and asked to buy a new machine

CodePudding user response:

reference 5 floor sun1976 reply: buying new machines

PC can't use the server, the server can't change the mainframe...
Software and hardware to system integration:
Sometimes deliberately performance is low, and asked to buy the new machine


Ha ha, if not you bought to the machine, it is not in vain ~

Is a serious slant the door oh

CodePudding user response:

As far as possible reduce the amount of data

CodePudding user response:

1. The memory is cheap now, increase the memory effect is best;
2. The SQL statements to lean
3. Check the results to partial display paging

CodePudding user response:

I think the most important data structure. This way later maintenance work to do. Should be best to improve the performance of the system.

CodePudding user response:

I don't know

CodePudding user response:

Improve the speed, with optical fiber, pretty soon
  • Related