search
HomeBackend DevelopmentPHP Tutorialphp读远程数据库的传输速度问题?

我现在有一些页面要挂到别人的网站,然后要从我的数据库读取数据到那些页面显示,如果直接mysql_connect()连接读取数据会不会很慢?会不会有很大的问题?因为还要在那些页面购买商品,然后跳到我们的后台付款···
  求大师的见解···


回复讨论(解决方案)

测试一下就知道了

基本上都不推荐这么做.让他将服务器托管到你们同个网段机房内.将服务器做一个内网数据,然后两个前端读内网数据服务器数据

挂到别人的网站,然后要从我的数据库读取数据
远程操作必然要慢些,这还好说
问题在于远程操作需要开放权限,稍有不慎就将你的数据全部暴露给对方了。
这应该不是你想要的,因为还有到 我们的后台付款

挂到别人的网站,然后要从我的数据库读取数据
远程操作必然要慢些,这还好说
问题在于远程操作需要开放权限,稍有不慎就将你的数据全部暴露给对方了。
这应该不是你想要的,因为还有到我们的后台付款
你好·· 
 是这样,我们有个购物的后台,但是前端想放在合作的网站去(可能是有多个网站),然后在合作的网站有一些单独的页面专门放我们网站的产品,然后点击购买跳到我们这里来付款成交。
 您觉得这样的想法现实吗,好实现吗?主要是安全性这块的难度是不是很高?

引用 3 楼 xuzuning 的回复:挂到别人的网站,然后要从我的数据库读取数据
远程操作必然要慢些,这还好说
问题在于远程操作需要开放权限,稍有不慎就将你的数据全部暴露给对方了。
这应该不是你想要的,因为还有到我们的后台付款
你好·· 
 是这样,我们有个购物的后台,但是前端想放在合作的网站去(可能是有多个网站),然后在合作的网站有一些单独的页面专门放我们网…… 如果是通过别人的网站来挂自己的东西,只是做个链接的话,其实也没什么的,要是涉及到付款什么的,还是谨慎点好的。

我明白你的意思,你是想把你们平台上的商品展未在其它商家网站上面。其实你们不需要开放mysql权限,因为这样别人有了数据库权限后对你们也是不安全的。
你可以了解一下其它方式的数据交互,如xml或webserver等,你们给他们提供一个这样的接口,要比你们直接给他们数据库操作权限好的多。

如果不是同一个机房,同一个交换机下,速度很慢的,最佳的方法还是做一个API接口给对方让对方去调

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
PHP Performance Tuning for High Traffic WebsitesPHP Performance Tuning for High Traffic WebsitesMay 14, 2025 am 12:13 AM

ThesecrettokeepingaPHP-poweredwebsiterunningsmoothlyunderheavyloadinvolvesseveralkeystrategies:1)ImplementopcodecachingwithOPcachetoreducescriptexecutiontime,2)UsedatabasequerycachingwithRedistolessendatabaseload,3)LeverageCDNslikeCloudflareforservin

Dependency Injection in PHP: Code Examples for BeginnersDependency Injection in PHP: Code Examples for BeginnersMay 14, 2025 am 12:08 AM

You 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?PHP Performance: is it possible to optimize the application?May 14, 2025 am 12:04 AM

Yes,optimizingaPHPapplicationispossibleandessential.1)ImplementcachingusingAPCutoreducedatabaseload.2)Optimizedatabaseswithindexing,efficientqueries,andconnectionpooling.3)Enhancecodewithbuilt-infunctions,avoidingglobalvariables,andusingopcodecaching

PHP Performance Optimization: The Ultimate GuidePHP Performance Optimization: The Ultimate GuideMay 14, 2025 am 12:02 AM

ThekeystrategiestosignificantlyboostPHPapplicationperformanceare:1)UseopcodecachinglikeOPcachetoreduceexecutiontime,2)Optimizedatabaseinteractionswithpreparedstatementsandproperindexing,3)ConfigurewebserverslikeNginxwithPHP-FPMforbetterperformance,4)

PHP Dependency Injection Container: A Quick StartPHP Dependency Injection Container: A Quick StartMay 13, 2025 am 12:11 AM

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Dependency Injection vs. Service Locator in PHPDependency Injection vs. Service Locator in PHPMay 13, 2025 am 12:10 AM

Select 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.PHP performance optimization strategies.May 13, 2025 am 12:06 AM

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHP Email Validation: Ensuring Emails Are Sent CorrectlyPHP Email Validation: Ensuring Emails Are Sent CorrectlyMay 13, 2025 am 12:06 AM

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

mPDF

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

SublimeText3 Chinese version

Chinese version, very easy to use

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools