Did you put MS-SQL server on the ASP server machine? Or did you put windows
2000 on that formerly bsd box.
Where both setups communicating over ethernet?
Or was the second setup a single box? (would be much faster)
An ASP server communicating to MS-SQL, even via ODBC, is probably as close
to optimized communication as you can get. I somehow can't imagine that
there is really any/much translation going on of SQL commands, which is what
ODBC does.
A better test would be PHP/Apache on the webserver, and then communicate to
either local or network mysql server or ms-SQL server.
That would be a better test.
SIDENOTE: are there any hooks in ASP to access MySQL if it was running on
the same box as the ASP server, without using ODBC?
Php has the range of mssql_() functions, what are all the methods of getting
data from MySQL for ASP?
On 3/27/01 2:34 PM, "Benjamin Pflugmann" <[EMAIL PROTECTED]> wrote:
> Hi.
>
> Well, there are too few information to say something concrete. Maybe,
> for your enviromnet, MS-SQL is really faster, maybe MySQL wasn't well
> tuned.
>
> Anyhow, I wanted to point out, that there are two MySQL ODBC drivers
> around, one with debugging enabled, the other one without debugging.
> The one with debugging is a magnitude slower than the other and this
> may already explain the difference you noticed.
>
> Btw, ODBC isn't really a fast access method, anyhow (and assume that
> MS has optimized out their own software).
>
> Any other pointers?
>
> Bye,
>
> Benjamin.
>
>
> On Tue, Mar 27, 2001 at 02:12:36PM -0800, [EMAIL PROTECTED] wrote:
>> Hey guys,
>>
>> Most of the accounts I have read about MySQL was that it was one of
>> the fastest databases around. Now, for development purposes I
>> created a FreeBSD system with JUST MySQL (no other major
>> processes). Then I created a separate Windows 2000 ASP server to
>> server as our development server for our new site. The two servers
>> communicated via ODBC.
>>
>> Anyways, a period of time elapsed and we decided to move to MS-SQL
>> server for feature reasons, and when we had the MS-SQL ODBC driver
>> point to the newly created MS-SQL server (roughly same specs), it
>> was like 50% faster! What gives? Is MySQL *really* that slow, MS-SQL
>> *really* that fast, or maybe there was some weird setting in the
>> ODBC driver or the MySQL server that I didn't switch right which
>> made it go slow. I am not sure.
>>
>> Or maybe Microsoft, in their monopolistic ways, created special
>> hooks between ASP and MS-SQL server to make the communication go
>> somehow faster. Anyone had similar experiences to mine?
>> - Steve
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
