字符串查找替换的效率高,还是存到数据库里,取出来拼接的效率高? - V2EX
Home
Sign Up
Sign In
V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member
Sign In
V2EX
问与答
字符串查找替换的效率高,还是存到数据库里,取出来拼接的效率高?
mfanming
Aug 16, 2016
1942 views
This topic created in 3553 days ago, the information mentioned may be changed or developed.
几百字
几百字
字符串操作:
1.查找横线,替换上面几百字
2.查找横线,替换下面几百字
数据库操作:
1.生成新的上面几百字,数据库取出下面几百字,拼接。上面几百字存入数据库
2.参考上面
php,mysql
Supplement 1
Aug 16, 2016
1.如果是字符串操作,我只需在数据库中占用一个字段 A ,然后从数据库中读取 A ,字符串查找 /替换,存入 A
2.如果是数据库操作,我需要另外增加两个数据库字段 B,C ,新字符串跟 B 或 C 拼接,存入 A
几百字
数据库
横线
查找
4 replies
1
SoloCompany
Aug 16, 2016
1
即使说 php 效率低,这么点字符串操作也不至于比数据库效率还低吧
2
SoloCompany
Aug 16, 2016
1
另外就是,你不会用 array join 来代替 preg_replace 的吗
3
mfanming
OP
Aug 16, 2016
@
SoloCompany
我是不知道,几百个字符的查询,对内存和 CPU 占用有多大
如果是数据库的话,分成两个字段存储,不需要查询操作,只是读取和存入。
4
mfanming
OP
Aug 16, 2016
@
SoloCompany
我又补充问题了,刚才自己看了一遍,没说清楚...
About
Help
Advertise
Blog
API
FAQ
Solana
2985 Online
Highest 6679
Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 31ms
UTC 11:32
PVG 19:32
LAX 04:32
JFK 07:32
Do have faith in what you're doing.
ubao
msn
snddm
index
pchome
yahoo
rakuten
mypaper
meadowduck
bidyahoo
youbao
zxmzxm
asda
bnvcg
cvbfg
dfscv
mmhjk
xxddc
yybgb
zznbn
ccubao
uaitu
acv
GXCV
ET
GDG
YH
FG
BCVB
FJFH
CBRE
CBC
GDG
ET54
WRWR
RWER
WREW
WRWER
RWER
SDG
EW
SF
DSFSF
fbbs
ubao
fhd
dfg
ewr
dg
df
ewwr
ewwr
et
ruyut
utut
dfg
fgd
gdfgt
etg
dfgt
dfgd
ert4
gd
fgg
wr
235
wer3
we
vsdf
sdf
gdf
ert
xcv
sdf
rwer
hfd
dfg
cvb
rwf
afb
dfh
jgh
bmn
lgh
rty
gfds
cxv
xcv
xcs
vdas
fdf
fgd
cv
sdf
tert
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
sdf
shasha9178
shasha9178
shasha9178
shasha9178
shasha9178
liflif2
liflif2
liflif2
liflif2
liflif2
liblib3
liblib3
liblib3
liblib3
liblib3
zhazha444
zhazha444
zhazha444
zhazha444
zhazha444
dende5
dende
denden
denden2
denden21
fenfen9
fenf619
fen619
fenfe9
fe619
sdf
sdf
sdf
sdf
sdf
zhazh90
zhazh0
zhaa50
zha90
zh590
zho
zhoz
zhozh
zhozho
zhozho2
lislis
lls95
lili95
lils5
liss9
sdf0ty987
sdft876
sdft9876
sdf09876
sd0t9876
sdf0ty98
sdf0976
sdf0ty986
sdf0ty96
sdf0t76
sdf0876
df0ty98
sf0t876
sd0ty76
sdy76
sdf76
sdf0t76
sdf0ty9
sdf0ty98
sdf0ty987
sdf0ty98
sdf6676
sdf876
sd876
sd876
sdf6
sdf6
sdf9876
sdf0t
sdf06
sdf0ty9776
sdf0ty9776
sdf0ty76
sdf8876
sdf0t
sd6
sdf06
s688876
sd688
sdf86