ADOdb (Page 1 of 2)

Yes, I have thought about it. I plan to look closer at it when 1.2 is released. One thing I don't like about it, and this may sound trivial to some people, is the odd naming scheme it uses. E.g. GetRow() instead of get_row() (which pretty much the rest of PHP uses). I guess it's a result of them trying to mimic ADO, but then again, I'm not very fond of ADO either :)

hmm, question is would anyone want it? i mean support for other databases

I used postnuke for a few months, the abstraction layer slowed it down from what I could see.

Most users of PunBB use MySQL, to slow it down for the few that want to use Access doesn't seem right.

See these benchmarks: http://www.english.rk.edu.pl/cms_benchmark.html

At the time I was testing it, PostNuke had recently forked away from PHPNuke.

One of the first things they did was go to an abstraction layer. I tested both on my system and PHPNuke was faster, the code hadn't been changed that much other than adding support for ADOdb.

From the benchmarks:
PHP Nuke 0,6907
Postnuke 1,2218

The only point of me raising this issue is to open up PunBB to a wider variety of database users, myself being an avid MySQL fan.

Ok, instead of making it part of the board package, what about just support for it built into the forum or make it optional download package?

Just trying to think of ways to get more people to use the board

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.

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.

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

It is common slander.

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.

no i don't think rickard's reaction was in any way anti-microsoft (nothing he said had any negative connotations especially the at the end), and by no one cares i mean in the case of punbb not in the general scheme of things

I want to use Microsoft Access with PunBB, is that possible

hcgtv's request != your request

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 )

I was there when Windows was distributed on 5 1/4 floppies. We all saw the potential and wanted to help Billy and the boys out, we thought back then that if we helped them grow, we would grow with them.

20 years later and the only software at the computer store that is not Microsoft's, is Anti-Virus and Games. They killed the software industry, their embrace and extend philosophy put a lot of good companies out of business, the same companies that helped them get a foothold in the small and medium sized business market.

I am anti-Microsoft, damn proud of it.