FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » PHP with MS SQL SERVER: is it suitable?
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
PHP with MS SQL SERVER: is it suitable? [message #181019] Sat, 06 April 2013 16:40 Go to next message
Giacomo M is currently offline  Giacomo M
Messages: 15
Registered: February 2013
Karma: 0
Junior Member
Hi everybody,
Is it suitable using PHP with MS SQL SERVER?

I mean, how the performance is?

Thank you

--
Giacomo
Re: PHP with MS SQL SERVER: is it suitable? [message #181022 is a reply to message #181019] Sat, 06 April 2013 18:28 Go to previous messageGo to next message
Jerry Stuckle is currently offline  Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
Senior Member
On 4/6/2013 12:40 PM, Giacomo M wrote:
> Hi everybody,
> Is it suitable using PHP with MS SQL SERVER?
>
> I mean, how the performance is?
>
> Thank you
>

Impossible to say without a LOT more information - especially the
conditions under which is running.

What you're asking is is the performance of a Honda Civic suitable.
Sure, for around town and on the highway. But I wouldn't try one on a
NASCAR track.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
Re: PHP with MS SQL SERVER: is it suitable? [message #181024 is a reply to message #181019] Sat, 06 April 2013 18:34 Go to previous messageGo to next message
Michael Vilain is currently offline  Michael Vilain
Messages: 88
Registered: September 2010
Karma: 0
Member
In article <kjpj66$rf$1(at)speranza(dot)aioe(dot)org>,
Giacomo M <kylnas(at)tiscali(dot)it> wrote:

> Hi everybody,
> Is it suitable using PHP with MS SQL SERVER?
>
> I mean, how the performance is?
>
> Thank you

PHP with MySQL is much more common. PHP is really optimized for the
Linux environment. If you get it to work, post what you did.

--
DeeDee, don't press that button! DeeDee! NO! Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]
Re: PHP with MS SQL SERVER: is it suitable? [message #181026 is a reply to message #181024] Sat, 06 April 2013 20:11 Go to previous messageGo to next message
Thomas 'PointedEars'  is currently offline  Thomas 'PointedEars'
Messages: 701
Registered: October 2010
Karma: 0
Senior Member
Michael Vilain wrote:

> Giacomo M <kylnas(at)tiscali(dot)it> wrote:
>> Hi everybody,
>> Is it suitable using PHP with MS SQL SERVER?
>>
>> I mean, how the performance is?
>
> PHP with MySQL is much more common.

ACK.

> PHP is really optimized for the Linux environment.

Nonsense.

> If you get it to work, post what you did.

RTFM and the AUP of your Usenet provider.


PointedEars
--
> If you get a bunch of authors […] that state the same "best practices"
> in any programming language, then you can bet who is wrong or right...
Not with javascript. Nonsense propagates like wildfire in this field.
-- Richard Cornford, comp.lang.javascript, 2011-11-14
Re: PHP with MS SQL SERVER: is it suitable? [message #181037 is a reply to message #181019] Sun, 07 April 2013 12:33 Go to previous messageGo to next message
Man-wai Chang is currently offline  Man-wai Chang
Messages: 11
Registered: December 2010
Karma: 0
Junior Member
On 7/04/2013 00:40, Giacomo M wrote:
> Is it suitable using PHP with MS SQL SERVER?
> I mean, how the performance is?

OS: Windows or Linux?

--
@~@ Remain silent. Nothing from soldiers and magicians is real!
/ v \ Simplicity is Beauty! May the Force and farces be with you!
/( _ )\ (Fedora 18 i686) Linux 3.8.5-201.fc18.i686
^ ^ 20:30:01 up 7:15 0 users load average: 0.00 0.01 0.05
不借貸! 不詐騙! 不援交! 不打交! 不打劫! 不自殺! 請考慮綜援 (CSSA):
http://www.swd.gov.hk/tc/index/site_pubsvc/page_socsecu/sub_addressesa
Re: PHP with MS SQL SERVER: is it suitable? [message #181039 is a reply to message #181037] Sun, 07 April 2013 12:46 Go to previous messageGo to next message
Giacomo M is currently offline  Giacomo M
Messages: 15
Registered: February 2013
Karma: 0
Junior Member
Il 07/04/2013 14:33, Mr. Man-wai Chang ha scritto:
> On 7/04/2013 00:40, Giacomo M wrote:
>> Is it suitable using PHP with MS SQL SERVER?
>> I mean, how the performance is?
>
> OS: Windows or Linux?

Windows.
The web site will be big with something like 1000 access per day.

--
Giacomo
Re: PHP with MS SQL SERVER: is it suitable? [message #181041 is a reply to message #181039] Sun, 07 April 2013 13:13 Go to previous messageGo to next message
M. Strobel is currently offline  M. Strobel
Messages: 386
Registered: December 2011
Karma: 0
Senior Member
Am 07.04.2013 14:46, schrieb Giacomo M:
> Il 07/04/2013 14:33, Mr. Man-wai Chang ha scritto:
>> On 7/04/2013 00:40, Giacomo M wrote:
>>> Is it suitable using PHP with MS SQL SERVER?
>>> I mean, how the performance is?
>>
>> OS: Windows or Linux?
>
> Windows.
> The web site will be big with something like 1000 access per day.
>

This is 0,7 accesses per minute. The cheapest Web Space will do.

/Str.
Re: PHP with MS SQL SERVER: is it suitable? [message #181046 is a reply to message #181037] Sun, 07 April 2013 14:24 Go to previous messageGo to next message
Robert Heller is currently offline  Robert Heller
Messages: 60
Registered: December 2010
Karma: 0
Member
At Sun, 07 Apr 2013 20:33:49 +0800 "Mr. Man-wai Chang" <toylet(dot)toylet(at)gmail(dot)com> wrote:

>
> On 7/04/2013 00:40, Giacomo M wrote:
>> Is it suitable using PHP with MS SQL SERVER?
>> I mean, how the performance is?
>
> OS: Windows or Linux?

MS SQL SERVER only runs on MS-Windows, so PHP with MS SQL SERVER pretty
much implies MS-Windows, unless one is accessing MS SQL SERVER via a
network connection (it is not generally not not considered a good idea
to access a SQL server (of any type) over a network connection,
partitularly a *public* Internet connection, from a security POV).
Note: accessing ANY SQL server over a network will be performance
limited by the network connection.

>

--
Robert Heller -- 978-544-6933 / heller(at)deepsoft(dot)com
Deepwoods Software -- http://www.deepsoft.com/
() ascii ribbon campaign -- against html e-mail
/\ www.asciiribbon.org -- against proprietary attachments
Re: PHP with MS SQL SERVER: is it suitable? [message #181050 is a reply to message #181039] Sun, 07 April 2013 15:06 Go to previous messageGo to next message
The Natural Philosoph is currently offline  The Natural Philosoph
Messages: 993
Registered: September 2010
Karma: 0
Senior Member
On 07/04/13 13:46, Giacomo M wrote:
> Il 07/04/2013 14:33, Mr. Man-wai Chang ha scritto:
>> On 7/04/2013 00:40, Giacomo M wrote:
>>> Is it suitable using PHP with MS SQL SERVER?
>>> I mean, how the performance is?
>>
>> OS: Windows or Linux?
>
> Windows.
> The web site will be big with something like 1000 access per day.
>
1/. 1000 accesses a *second* is BIG.

2/. BIG and 'using windows' should never be uttered in the same sentence


--
Ineptocracy

(in-ep-toc’-ra-cy) – a system of government where the least capable to
lead are elected by the least capable of producing, and where the
members of society least likely to sustain themselves or succeed, are
rewarded with goods and services paid for by the confiscated wealth of a
diminishing number of producers.
Re: PHP with MS SQL SERVER: is it suitable? [message #181065 is a reply to message #181046] Mon, 08 April 2013 11:05 Go to previous messageGo to next message
Man-wai Chang is currently offline  Man-wai Chang
Messages: 11
Registered: December 2010
Karma: 0
Junior Member
On 7/04/2013 22:24, Robert Heller wrote:
>> OS: Windows or Linux?
>
> MS SQL SERVER only runs on MS-Windows, so PHP with MS SQL SERVER pretty
> much implies MS-Windows, unless one is accessing MS SQL SERVER via a

You could use a virtual machine to run M$ SQL $erver inside Linux! Not
sure if Wine could cut it... Anyway, don't overload it! :)


--
@~@ Remain silent. Nothing from soldiers and magicians is real!
/ v \ Simplicity is Beauty! May the Force and farces be with you!
/( _ )\ (Fedora 18 i686) Linux 3.8.5-201.fc18.i686
^ ^ 18:57:02 up 7 min 0 users load average: 0.00 0.25 0.22
不借貸! 不詐騙! 不援交! 不打交! 不打劫! 不自殺! 請考慮綜援 (CSSA):
http://www.swd.gov.hk/tc/index/site_pubsvc/page_socsecu/sub_addressesa
Re: PHP with MS SQL SERVER: is it suitable? [message #181069 is a reply to message #181065] Tue, 09 April 2013 03:58 Go to previous messageGo to next message
Michael Vilain is currently offline  Michael Vilain
Messages: 88
Registered: September 2010
Karma: 0
Member
In article <kju84k$5ac$4(at)dont-email(dot)me>,
"Mr. Man-wai Chang" <toylet(dot)toylet(at)gmail(dot)com> wrote:

> On 7/04/2013 22:24, Robert Heller wrote:
>>> OS: Windows or Linux?
>>
>> MS SQL SERVER only runs on MS-Windows, so PHP with MS SQL SERVER pretty
>> much implies MS-Windows, unless one is accessing MS SQL SERVER via a
>
> You could use a virtual machine to run M$ SQL $erver inside Linux! Not
> sure if Wine could cut it... Anyway, don't overload it! :)

I seem to recall that MS SQL SERVER is engineered to require a real
system to run. It won't run in a VM. Leastways that the way it was a
few years ago. Maybe MS changed SQL SERVER to support running in a VM.

--
DeeDee, don't press that button! DeeDee! NO! Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]
Re: PHP with MS SQL SERVER: is it suitable? [message #181070 is a reply to message #181069] Tue, 09 April 2013 08:24 Go to previous messageGo to next message
M. Strobel is currently offline  M. Strobel
Messages: 386
Registered: December 2011
Karma: 0
Senior Member
Am 09.04.2013 05:58, schrieb Michael Vilain:
> In article <kju84k$5ac$4(at)dont-email(dot)me>,
> "Mr. Man-wai Chang" <toylet(dot)toylet(at)gmail(dot)com> wrote:
>
>> On 7/04/2013 22:24, Robert Heller wrote:
>>>> OS: Windows or Linux?
>>>
>>> MS SQL SERVER only runs on MS-Windows, so PHP with MS SQL SERVER pretty
>>> much implies MS-Windows, unless one is accessing MS SQL SERVER via a
>>
>> You could use a virtual machine to run M$ SQL $erver inside Linux! Not
>> sure if Wine could cut it... Anyway, don't overload it! :)
>
> I seem to recall that MS SQL SERVER is engineered to require a real
> system to run. It won't run in a VM. Leastways that the way it was a
> few years ago. Maybe MS changed SQL SERVER to support running in a VM.
>
Just looked it up, VMware vSphere is selling as MS SQL Server platform, and licensing
for MS SQL Server 2012 has entries for VM licences.


/Str.
Re: PHP with MS SQL SERVER: is it suitable? [message #181071 is a reply to message #181070] Tue, 09 April 2013 08:32 Go to previous message
JohnT is currently offline  JohnT
Messages: 16
Registered: April 2011
Karma: 0
Junior Member
On Tue, 09 Apr 2013 10:24:13 +0200, M. Strobel wrote:

> Am 09.04.2013 05:58, schrieb Michael Vilain:

>> I seem to recall that MS SQL SERVER is engineered to require a real
>> system to run. It won't run in a VM. Leastways that the way it was a
>> few years ago. Maybe MS changed SQL SERVER to support running in a VM.
>>
> Just looked it up, VMware vSphere is selling as MS SQL Server platform,
> and licensing for MS SQL Server 2012 has entries for VM licences.
>
>
> /Str.

Running SQL Server here in a VMWare VM with no issues.

I'm working on a website that I'm slowly converting to PHP.
Half is running ASP, and half PHP. All running in a windows VM without
any issues (once I figured out what the connect string was !).

I wouldn't have chosen SQL Server if I'd had the choice, but that's what
I've got to work with, and it works as well as SQL Server ever does.

Regards
JohnT
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Connecting to MySQL server....
Next Topic: Best Framework for big multilanguage site
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 23:18:45 GMT 2024

Total time taken to generate the page: 0.02766 seconds