Development Discussion Board

As far I know we use the default engine when installing, and dont provide a engine when creating the tables. That's what I thought too since when I installed 3.1 it was showing Innodb for all phpbb tables. If no storage engine is specified then the default engine will be chosen which is based on th...

But if DBAL doesn't use anything specific features that is only available in MyIsam, shouldn't it technically support Innodb already? It might not be ready to use the additional power this storage engine provides but that would not necessary mean DBAL doesn't support it. There is a high chance that ...

I know. I also read some ridiculous argument over silly things between the php developers (rasmus and another guy) dated in 2002 on the idea of introducing array() into php. Rasmus was against it saying it made more sense to leave it as [1,2,3] than using a new system like array(1,2,3). 12 years lat...

AFAIK, phpBB does not use FullText search nor spartial indexes so it is ready for InnoDB. It just does not use InnoDB to its fullest such as foreign keys which would be its greatest gain in performance. That is great to hear. Then with 3.1, would you guys consider adding phpbb default engine as Inn...

If using latest version of WAMPSERVER, if I'm correct (have used it) think its configured to InnoDB as DB storage engine first. Unless phpBB 3.1 can use both types of storage engine and my online web server is setup to use MyISAM first. So could be that phpBB 3.1 does support both types then, but a...

Out of curiosity why do you want to use InnoDB, I know the difference about tables not locking up with InnoDB, but from what I've read in past its geared more towards benefiting very large active forums. Do you have a very large forum, because if not MyISAM will run faster of the two for your board...

On the same note, can I ask what could be an ideal setting for MyIsam when I have a server with 8GB Ram? Look I understand that it is hard to give suggestion without testing out the sql demand, current usage statistics, etc.. but this is for a new server and I want to be ready with an ideal setting ...

News to me if 3.1 is using InnoDB, I'm running it and all tables are MyISAM. From what I can see 3.1 is still using MyISAM, not InnoDB as default for database storage engine. hmm.... thats interesting. I had a test set-up for phpbb 3.1 RC3 in my WAMP server that was installed a few months ago and w...

Correct me if I am wrong. But from my memory, I think the older version of php (upto 3.0.12) is using MyISAM as the storage engine and the 3.1 uses InnoDB storage engine, is that right? (This is what I understood when I was looking at the sql tables). If this is the case, when I upgrade 3.0.12 board...

Good enough for me... thanks.