Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #8960 > unrolled thread

PHP with MS SQL SERVER: is it suitable?

Started byGiacomo M <kylnas@tiscali.it>
First post2013-04-06 18:40 +0200
Last post2013-04-09 08:32 +0000
Articles 13 — 9 participants

Back to article view | Back to comp.lang.php

Contents

  PHP with MS SQL SERVER: is it suitable? Giacomo M <kylnas@tiscali.it> - 2013-04-06 18:40 +0200
    Re: PHP with MS SQL SERVER: is it suitable? Jerry Stuckle <jstucklex@attglobal.net> - 2013-04-06 14:28 -0400
    Re: PHP with MS SQL SERVER: is it suitable? Michael Vilain <vilain@NOspamcop.net> - 2013-04-06 11:34 -0700
      Re: PHP with MS SQL SERVER: is it suitable? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-04-06 22:11 +0200
    Re: PHP with MS SQL SERVER: is it suitable? "Mr. Man-wai Chang" <toylet.toylet@gmail.com> - 2013-04-07 20:33 +0800
      Re: PHP with MS SQL SERVER: is it suitable? Giacomo M <kylnas@tiscali.it> - 2013-04-07 14:46 +0200
        Re: PHP with MS SQL SERVER: is it suitable? "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2013-04-07 15:13 +0200
        Re: PHP with MS SQL SERVER: is it suitable? The Natural Philosopher <tnp@invalid.invalid> - 2013-04-07 16:06 +0100
      Re: PHP with MS SQL SERVER: is it suitable? Robert Heller <heller@deepsoft.com> - 2013-04-07 09:24 -0500
        Re: PHP with MS SQL SERVER: is it suitable? "Mr. Man-wai Chang" <toylet.toylet@gmail.com> - 2013-04-08 19:05 +0800
          Re: PHP with MS SQL SERVER: is it suitable? Michael Vilain <vilain@NOspamcop.net> - 2013-04-08 20:58 -0700
            Re: PHP with MS SQL SERVER: is it suitable? "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2013-04-09 10:24 +0200
              Re: PHP with MS SQL SERVER: is it suitable? JohnT <john@example.com> - 2013-04-09 08:32 +0000

#8960 — PHP with MS SQL SERVER: is it suitable?

FromGiacomo M <kylnas@tiscali.it>
Date2013-04-06 18:40 +0200
SubjectPHP with MS SQL SERVER: is it suitable?
Message-ID<kjpj66$rf$1@speranza.aioe.org>
Hi everybody,
Is it suitable using PHP with MS SQL SERVER?

I mean, how the performance is?

Thank you

-- 
Giacomo

[toc] | [next] | [standalone]

#8963

FromJerry Stuckle <jstucklex@attglobal.net>
Date2013-04-06 14:28 -0400
Message-ID<kjppb2$ukc$1@dont-email.me>
In reply to#8960
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@attglobal.net
==================

[toc] | [prev] | [next] | [standalone]

#8965

FromMichael Vilain <vilain@NOspamcop.net>
Date2013-04-06 11:34 -0700
Message-ID<vilain-FC043A.11343606042013@news.individual.net>
In reply to#8960
In article <kjpj66$rf$1@speranza.aioe.org>,
 Giacomo M <kylnas@tiscali.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]

[toc] | [prev] | [next] | [standalone]

#8967

FromThomas 'PointedEars' Lahn <PointedEars@web.de>
Date2013-04-06 22:11 +0200
Message-ID<2115503.DhVHKmByyt@PointedEars.de>
In reply to#8965
Michael Vilain wrote:

> Giacomo M <kylnas@tiscali.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

[toc] | [prev] | [next] | [standalone]

#8978

From"Mr. Man-wai Chang" <toylet.toylet@gmail.com>
Date2013-04-07 20:33 +0800
Message-ID<kjrouh$o4u$1@dont-email.me>
In reply to#8960
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

[toc] | [prev] | [next] | [standalone]

#8980

FromGiacomo M <kylnas@tiscali.it>
Date2013-04-07 14:46 +0200
Message-ID<kjrprg$khc$1@speranza.aioe.org>
In reply to#8978
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

[toc] | [prev] | [next] | [standalone]

#8982

From"M. Strobel" <sorry_no_mail_here@nowhere.dee>
Date2013-04-07 15:13 +0200
Message-ID<asd9nvF4n7vU1@mid.uni-berlin.de>
In reply to#8980
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.

[toc] | [prev] | [next] | [standalone]

#8992

FromThe Natural Philosopher <tnp@invalid.invalid>
Date2013-04-07 16:06 +0100
Message-ID<kjs213$pa5$2@news.albasani.net>
In reply to#8980
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.

[toc] | [prev] | [next] | [standalone]

#8988

FromRobert Heller <heller@deepsoft.com>
Date2013-04-07 09:24 -0500
Message-ID<UY2dnYyPJeMSHPzMnZ2dnUVZ_hSdnZ2d@giganews.com>
In reply to#8978
At Sun, 07 Apr 2013 20:33:49 +0800 "Mr. Man-wai Chang" <toylet.toylet@gmail.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@deepsoft.com
Deepwoods Software        -- http://www.deepsoft.com/
()  ascii ribbon campaign -- against html e-mail
/\  www.asciiribbon.org   -- against proprietary attachments

[toc] | [prev] | [next] | [standalone]

#9007

From"Mr. Man-wai Chang" <toylet.toylet@gmail.com>
Date2013-04-08 19:05 +0800
Message-ID<kju84k$5ac$4@dont-email.me>
In reply to#8988
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

[toc] | [prev] | [next] | [standalone]

#9012

FromMichael Vilain <vilain@NOspamcop.net>
Date2013-04-08 20:58 -0700
Message-ID<vilain-4B0511.20575908042013@news.individual.net>
In reply to#9007
In article <kju84k$5ac$4@dont-email.me>,
 "Mr. Man-wai Chang" <toylet.toylet@gmail.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]

[toc] | [prev] | [next] | [standalone]

#9013

From"M. Strobel" <sorry_no_mail_here@nowhere.dee>
Date2013-04-09 10:24 +0200
Message-ID<asi1hdF6onrU1@mid.uni-berlin.de>
In reply to#9012
Am 09.04.2013 05:58, schrieb Michael Vilain:
> In article <kju84k$5ac$4@dont-email.me>,
>  "Mr. Man-wai Chang" <toylet.toylet@gmail.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.

[toc] | [prev] | [next] | [standalone]

#9014

FromJohnT <john@example.com>
Date2013-04-09 08:32 +0000
Message-ID<kk0jnq$f3p$1@dont-email.me>
In reply to#9013
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

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.php

csiph-web