1

(29 replies, posted in PunBB 1.2 discussion)

Once again, I am not anti-Microsoft. I am however, open-minded. Actually, you're the one who started accusing MySQL of being slow compared to MSSQL.

I meant to defend ADO and the primary use of ADO from the now positively
insincere hcgtv, slandering ADO by implicating it with Access with purpose. mad

Official? You mean post a link to some Microsoft sponsored benchmark?

Hahaha lol

No, my own benchmarks, others' benchmarks, and industry standard benchmarks. big_smile

It is funny you mention Microsoft sponsored benchmarks though, since MySQL is the one
who refuses to participate in very well respected industry standard benchmarks with Oracle,
DB2 and MSSQL, instead choosing to provide their own executed by no independent party. hmm

I don't care if MySQL is simple and effective, ie. a "kids" database to some. I might even
prefer that in many situations. However, I do care if it is simply much slower than MSSQL.
I love alternative databases and have investigated and used over the years. I would so
love to use MySQL and libmysql... but it is slow tongue

I can make my apps use MySQL, MS SQL and a few other databases with a one line change.
This came about through extensive research and my eventual conclusion, collaborated by
many, that MS SQL is a much more efficient choice, resulting in greatly increased speed. wink

I have since found many smart people, large organizations and independent developers
who have learned the same. If MS SQL was MySQL and MySQL was MS SQL, many of you
would be on repeat about the difference in performance. yikes

All I mean to say was what I originally said and it stands. It is true and valid. Just because
Microsoft's solution is better does not mean I must be a Microsoft employee. If it does,
then I must thank you for the great compliment. (even though it was meant as an insult) cool

PS. Tagging outbursts with feigned smilies is as prevalent as using them in earnest. smile

2

(29 replies, posted in PunBB 1.2 discussion)

Connorhd wrote:

hcgtv's request != your request tongue

ADOdb does support access (not that i think punbb should use ADOdb, infact i would be more than happy for it to just use mysql i'm sure it would make rickard's life a whole lot simpler wink)

From my perspective, he was not being serious. I read it as a joke since he
was previously sounding anti-ADO by implying ADO advocation meant slowing
down PunBB for a few users that wanted to use Access. See his old post.

That seemed entirely facetious so I want to explicitly say that ADO != MS Access.

Some people, to varying degrees throughout its short history, believed ADO
"meant" Access when in fact that was another 3 letter acronym, not ADO.

To imply ADO means using Access is either ignorance or slander.

Edit: His sarcasm is blatantly obvious, why can't you see it?

3

(29 replies, posted in PunBB 1.2 discussion)

Access != MSSQL/MSDE

4

(29 replies, posted in PunBB 1.2 discussion)

Consider reading my initial reply carefully. Words matter.

5

(29 replies, posted in PunBB 1.2 discussion)

why is rickard's reaction anti-microsoft?

It is. You know it. Everyone knows it. I will not argue that.

It is common slander.

who cares if its php that is slowing down mssql?

I care. Others care. People who might want to use MSSQL care,
for PunBB or not. People who might want to use MySQL care,
for PunBB or not. Many people care. Many of them are smart.

Someone may want to fix it, especially someone concerned
with performance, which is the focus of my original post and
Rickard's reply. To concede PHP works slowly with MSSQL
is something entirely different than proclaiming MySQL beats
MSSQL any time of the day.

6

(29 replies, posted in PunBB 1.2 discussion)

I guess I can't argue with you, but that first line is absolutely classless.

Why would I want to argue? Why would I want to help people after that?

Is your experience with MSSQL only through PHP? Have you seen industry
benchmarks? Have you written your own? I have... Oh how I wish MySQL
was near MSSQL performance-wise.

I am going to invest a bunch of time in this yet again... but every time I
do anything like this I say I won't do it again, because I am always right.

Why are anti-Microsoft reactions so very much like the reactions of racists.
If that offends you, good. Stop acting like that. Yes, I know who you are.
I don't mean to offend you, but I thought someone with your clout would
not have to resort to that bs.

MySQL most definitely does NOT beat MSSQL any time of time, even for
straight up SELECTS. Most definitely not. I will make it official if I have time.

I have a list of changing user accounts. I want to use this with PunBB.

The accounts consist of an e-mail and password. Additions and removals
to/from this list occur without PunBB notification. It makes sense to me
that allowing PunBB to authenticate these users would be best done by
allowing these users to login with their existing e-mail and password.

I would like them to be able to have a username, but not modify their
account settings e-mail and password. ie. Any modification would be
pointless, as I will not write code to update that information at source.

I assume this require PunBB modification, but I don't know how much.

I would appreciate thoughts on the idea, some startup information
and possible things to worry about with respect to PunBB internals.

8

(29 replies, posted in PunBB 1.2 discussion)

So everyone knows, ADO would allow use of MSSQL and MSDE (free).
MSDE/MSSQL is a real database much faster than even precious MySQL.

The fact that PHP runs so well in *nix and MSDE requires Win32 is definitely a
huge dilemma, but I don't think it is fair to say ADO is going to slow you down.

ADO with MSDE/MSSQL is not slow. ADO with MSDE/MSSQL blows away MySQL.