sql server - Why is PHP -> MSSQL very slow when the DB is not on the same machine as the PHP code -


in course of trying move our website azure, we've found problem our php code talking mssql.

on current dedicated host (hosting both php , db), going page typically takes less 2 seconds. i've run queries necessary through ssms , take less 1 second. amount of data being returned queries small - 10-20 records, less 100kb in total.

with website hosted on azure (connecting azure sql database) same page takes around 40 seconds load. further investigation showed might caused database not being on same machine php - when original website pointed @ remote database (either dedicated machine or azure sql instance) page load time goes 40 second range.

in azure case, both website , db located in same region (n europe). when testing using our machines, both located in uk.

the current webhosting machine running php 5.4 , microsoft sql server express edition. azure website running on php 5.4.

in both cases we're using 3.0.1 microsoft sqlsrv drivers

how can improve performance when connecting remote sql db?

this question has been cross-posted server fault @ https://serverfault.com/questions/496505/why-is-php-mssql-very-slow-when-the-db-is-not-on-the-same-machine-as-the-php

no clue why response time jumps 2 40 seconds, but... few things consider:

  • if sql database instance in data center, you'll see both latency , bandwidth charges. if data centers separated continent (e.g. 1 in west, 1 in hong kong), you'll see more latency than, say, west <--> east).
  • if you're transferring significant amount of data result of query, bound network pipe size. 100mbps per core, small (xs) instances have 5mbps bandwidth.

you mentioned testing query in sql server management studio (at least i'm assuming sms ssms). query performance when testing against sql database? if it's close 40-second mark, quite possibly there's missing index when data ported local database sql database instance.


Comments

Post a Comment

Popular posts from this blog

monitor web browser programmatically in Android? -

i've got tricky question here. need users make payment bank (namely barclaycard) in uk. so, have https url , add parameters (such amount pay, order reference, etc) url, start http connection intent.actionview, redirect user browser can enter credit card details on bank's webpage , make payment our account successfully. far ? the code use below (i changed values privacy reasons) problem is, need app when user has completed/failed/cancelled payment. barclaycardautomatically redirects particular url when payment has succeeded, 1 if failed. there no way of knowing when barclaycard payment has succeeded go android app somehow ? button cardbutton = (button) findviewbyid(r.id.card_button); cardbutton.setonclicklistener(new view.onclicklistener() { @override public void onclick(view arg0) { string prehashstring = new string(); string prohashstring = new string(); string shapassphrase = new string(); shapassphrase = "gsvth£h70zkh...
Read more

Shrink a YouTube video to responsive width -

i have youtube video embedded on our website , when shrink screen tablet or phone sizes stops shrinking @ around 560px in width. standard youtube videos or there can add code make go smaller? you can make youtube videos responsive css. wrap iframe in div class of "videowrapper" , apply following styles: .videowrapper { float: none; clear: both; width: 100%; position: relative; padding-bottom: 56.25%; padding-top: 25px; height: 0; } .videowrapper iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } the .videowrapper div should inside responsive element. padding on .videowrapper necessary keep video collapsing. may have tweak numbers depending upon layout.
Read more

wpf - PdfWriter.GetInstance throws System.NullReferenceException -

i'm trying create pdf document using itextsharp 5.3.4 using following document document = new document(); filestream stm = new filestream(filename, filemode.create); pdfwriter writer = pdfwriter.getinstance(document, stm); i'm getting system.nullreferenceexception following stack trace: system.nullreferenceexception occurred hresult=-2147467261 message=la référence d'objet n'est pas définie à une instance d'un objet. source=itextsharp stacktrace: à itextsharp.text.version.getinstance() innerexception: i've verified neither document nor stm null, , if select "continue" in vs12 document created - exception thrown. updated itextsharp 5.4.0 , it's still occurring. can't find information on anywhere - got ideas? make sure not catching exceptions. nullreferenceexception can 1 caught , handled inside itextsharp, don't care it. fact can continue supports theory. change following setting verify: debug -> exceptions ...
Read more