现在有个需求是要把用户发表评论中带的图片自动归类成用户相册方便其他用户浏览，以前是有把图片地址保存在数据库里，如果每次查看相册的话都会查询数据库，现在想如果直接遍历用户相册文件夹下面的图片来浏览相册，哪种方式比较好？不知道大神们看懂了没？
回复讨论(解决方案)
建议你还是用以前的方式做，图片地址存数据库里面。图片保存在硬盘里面。不过你需要将图片关联上用户。
遍历用户相册文件夹的话，难不成每个用户都建一个文件夹吗？
建议你还是用以前的方式做，图片地址存数据库里面。图片保存在硬盘里面。不过你需要将图片关联上用户。
遍历用户相册文件夹的话，难不成每个用户都建一个文件夹吗？
现在纠结的时候如果表数据大的话，那查询的时候不就很慢了，如果在文件夹里遍历应该会比较快点吧
把图片地址存入json扩展
把图片地址存入json扩展
什么意思？能说明白点？图片用json格式存入数据库?
每次查看相册的话都会查询数据库
这是很正常的，数据库就是干这个的，累不死
如果表数据大的话，那查询的时候不就很慢了
想当然了吧？
至多对用户id做一个索引
如果在文件夹里遍历应该会比较快点吧
又是想当然了！
数据库查询是在一个文件中进行的，而文件夹遍历是在硬盘中进行的
你说那个快？
每次查看相册的话都会查询数据库
这是很正常的，数据库就是干这个的，累不死
如果表数据大的话，那查询的时候不就很慢了
想当然了吧？
至多对用户id做一个索引
如果在文件夹里遍历应该会比较快点吧
又是想当然了！
数据库查询是在一个文件中进行的，而文件夹遍历是在硬盘中进行的
你说那个快？
多谢版主的回答，用户id是有做索引的。我知道该怎么做了。多谢！
把图片地址存入json扩展
什么意思？能说明白点？图片用json格式存入数据库?
是的
PHP Performance Tuning for High Traffic WebsitesMay 14, 2025 am 12:13 AMThesecrettokeepingaPHP-poweredwebsiterunningsmoothlyunderheavyloadinvolvesseveralkeystrategies:1)ImplementopcodecachingwithOPcachetoreducescriptexecutiontime,2)UsedatabasequerycachingwithRedistolessendatabaseload,3)LeverageCDNslikeCloudflareforservin
Dependency Injection in PHP: Code Examples for BeginnersMay 14, 2025 am 12:08 AMYou should care about DependencyInjection(DI) because it makes your code clearer and easier to maintain. 1) DI makes it more modular by decoupling classes, 2) improves the convenience of testing and code flexibility, 3) Use DI containers to manage complex dependencies, but pay attention to performance impact and circular dependencies, 4) The best practice is to rely on abstract interfaces to achieve loose coupling.
PHP Performance: is it possible to optimize the application?May 14, 2025 am 12:04 AMYes,optimizingaPHPapplicationispossibleandessential.1)ImplementcachingusingAPCutoreducedatabaseload.2)Optimizedatabaseswithindexing,efficientqueries,andconnectionpooling.3)Enhancecodewithbuilt-infunctions,avoidingglobalvariables,andusingopcodecaching
PHP Performance Optimization: The Ultimate GuideMay 14, 2025 am 12:02 AMThekeystrategiestosignificantlyboostPHPapplicationperformanceare:1)UseopcodecachinglikeOPcachetoreduceexecutiontime,2)Optimizedatabaseinteractionswithpreparedstatementsandproperindexing,3)ConfigurewebserverslikeNginxwithPHP-FPMforbetterperformance,4)
PHP Dependency Injection Container: A Quick StartMay 13, 2025 am 12:11 AMAPHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.
Dependency Injection vs. Service Locator in PHPMay 13, 2025 am 12:10 AMSelect DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.
PHP performance optimization strategies.May 13, 2025 am 12:06 AMPHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi
PHP Email Validation: Ensuring Emails Are Sent CorrectlyMay 13, 2025 am 12:06 AMPHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
SublimeText3 Chinese version
Chinese version, very easy to use
WebStorm Mac version
Useful JavaScript development tools
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver Mac version
Visual web development tools
