Need for speed ...

General project discussion. NOT for help questions.
Locked
cyberman

Need for speed ...

Post by cyberman »

Why CMS doesn't use pure MySQL instead ADODB ?

I don't know someone, who's using CMS and Postgres. In german forum there are some users, which make a try to rewrite CMS to MySQL. And what should I say - CMS speeds up to 400%. And the work isn't completely done ...
Ted
Power Poster
Power Poster
Posts: 3329
Joined: Fri Jun 11, 2004 6:58 pm

Re: Need for speed ...

Post by Ted »

I get bug reports all the time from people who have issues with postgres.  Plus, part of my plam is to support SQLite so that people with PHP5 don't have to setup a database at all!

I think people should be spending their time trying to figure out why ADODB is so slow.  I know it's not the driver area, since I've looked at the code and it's pretty minimal.

I'd rather look forward, instead of locking it into one database driver.  What happens when the mysql driver goes and mysqli is the only one left?  Rewrite the whole thing?

I'm sorry, but I can't see going foward with that.  I'd rather fix the problem instead.
Ted
Power Poster
Power Poster
Posts: 3329
Joined: Fri Jun 11, 2004 6:58 pm

Re: Need for speed ...

Post by Ted »

I didn't know adodb lite existed.  Very cool.  I'd be willing to give it a shot and see how well it works...

http://adodblite.sourceforge.net
cyberman

Re: Need for speed ...

Post by cyberman »

Any results ?
Ted
Power Poster
Power Poster
Posts: 3329
Joined: Fri Jun 11, 2004 6:58 pm

Re: Need for speed ...

Post by Ted »

Sorry.  It's been a little crazy last week or so.

I tried it, but it didn't support some major things.  Of course, I can't remember what they are at the moment, but it would've required me to do some serious additions to the drivers or a lot of work to CMSMS for it to work.  I just don't have the time now to pursue anything that extensive at the moment.
cyberman

Re: Need for speed ...

Post by cyberman »

Thx.
Locked

Return to “General Discussion”