数据库提取或php生成之间的最佳性能方案是什么

Question

I have a scenario where I just cannot put together which would yield the best performance results. My desire is performance,

I have a few big strings stored in a SQL database

Example:

0,0,0,0,0,0,0,0,0,2,4,4,0,0,0 - This can be (Say 1000 - 20000) characters long(Mostly 0's)

Now I would like to know what will be the best for performance. To keep them in the above format and dong a mysqli fetch or to convert it to something like:

Compressed Example: C0-9,2,4,4,C0-3

Where the number following the - a count. Then to reconvert them before usage. There are mostly huge blocks of 0's so I don't need to worry about condensing other numbers like this.

I know that the second option will have a positive effect on my database sizes. But I am not sure about optimum performance in this case.

Answer 1

You can do compression within PHP itself, which would be more efficient than trying it yourself.

link to gzcompress()

The basic idea is that you can compress the data when putting it into the database, then decompress it on the way back out. It will improve performance since MySQL will have less memory in use, and function calls are not hugely costly