|
Re: PHP with MS SQL SERVER: is it suitable? [message #181022 is a reply to message #181019] |
Sat, 06 April 2013 18:28 |
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 #181026 is a reply to message #181024] |
Sat, 06 April 2013 20:11 |
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 #181039 is a reply to message #181037] |
Sun, 07 April 2013 12:46 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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
|
|
|