All geek questions in one place

Get MySQL data without server stress

I am wondering what is the best way to prevent my server from stress when I want to get a lot of data using PHP.

Converting all my data to an XML sheet? Use caching?

Data comes from different databases and different tables.

Any ideas?

Thanks in advance

+3
source share
3 answers

  • Before doing anything, call him until he breaks.

  • When it breaks, project it to determine the breakpoint, and work on it.

  • Repeat from point 1 until performance limits are acceptable.

+4
source

None.

PHP-. XML - , XML, . XML - .

MySQL . -. , , .

OLTP , OLAP .

OTOH, , aleswhere - , scema.

.

+1

I think that caching will be a way, unless this data does not change very often :)

0
source

Source: https://habr.com/ru/post/1734679/

More articles:


All Articles