Search found 138 matches

by Prince of area51
Fri Jan 11, 2008 11:56 am
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 58477

Re: SQL optimisation

I agree to poyntesm, its much like developing a website, we all know IE 7 isn't the best browser but we have to deal with it because we all know most of our users will be using that. What I can suggest is MODs for DBMS you are using like if using LEFT JOINs make queries faster in PostgreSQL, than so...
by Prince of area51
Thu Jan 10, 2008 1:18 pm
Forum: [3.0/Olympus] Discussion
Topic: Transactions and MyISAM
Replies: 7
Views: 7489

Re: Transactions and MyISAM

Yes, indeed and I think it would not be a bad idea to have all the tables use InnoDB engine.
by Prince of area51
Thu Jan 10, 2008 12:45 pm
Forum: [3.0/Olympus] Discussion
Topic: Transactions and MyISAM
Replies: 7
Views: 7489

Re: Transactions and MyISAM

Transactions are only performed on *some* tables, so for those to work with the transactions, it’s best if they are InnoDB, but not all your tables would need to be InnoDB. I assuming that as so much work was put into making the code transaction-based, there must be some (good) reason behind that, ...
by Prince of area51
Wed Jan 09, 2008 5:01 pm
Forum: [3.0/Olympus] Discussion
Topic: Transactions and MyISAM
Replies: 7
Views: 7489

Re: Transactions and MyISAM

So, in other words, the recommended engine for phpBB 3 is InnoDB? Gosh, can't believe I didn't know that :o

And oh, thanks for replying, I'm chuffed to bits :lol:
by Prince of area51
Wed Jan 09, 2008 4:22 pm
Forum: [3.0/Olympus] Discussion
Topic: Transactions and MyISAM
Replies: 7
Views: 7489

Transactions and MyISAM

Hi, Something I was trying to ask for some time but couldn't summon enough courage. Luckily today I'm feeling a lil bit looney so here goes. I thought MyISAM table engine in MySQL did not support transactions, yet phpBB 3.0 uses a lot of transaction commits and roll-backs. I usually run phpBB on myS...
by Prince of area51
Fri Dec 21, 2007 11:37 am
Forum: [3.0/Olympus] Discussion
Topic: phpBB 3.2 Discussion
Replies: 257
Views: 226609

Re: phpBB 3.2 Discussion

If Quick Reply Mod would've taken me 30 minutes to install, I would've made an issue about it. The problem (which I think) with adding Quick Reply in the core is requests for it, sooner or later it would become the post reply page at the button of the page (with all the bbcodes, smilies, etc). Thats...
by Prince of area51
Thu Dec 20, 2007 2:47 pm
Forum: [3.0/Olympus] Discussion
Topic: phpBB 3.2 Discussion
Replies: 257
Views: 226609

Re: phpBB 3.2 Discussion

Well I personally thing 'roles' make it easier to handle permissions. What lacks is an explanation and understanding. I do plan to do some flash videos explaining what are roles and how they make the permission system a walk in the park. I've found that creating forums and assigning permissions in O...
by Prince of area51
Thu Dec 20, 2007 1:36 am
Forum: [3.0/Olympus] Discussion
Topic: phpBB 3.2 Discussion
Replies: 257
Views: 226609

Re: phpBB 3.2 Discussion

lol let stick more to the phpBB 3.2 and less to who should handle what and how (another topic can be started for that). Quick Reply MOD is not going to be part of the core (lets say not for 3.2 for arguments sake_ and move onwards with the discussion about 3.2 :)
by Prince of area51
Wed Dec 19, 2007 2:56 pm
Forum: [3.0/Olympus] Discussion
Topic: phpBB 3.2 Discussion
Replies: 257
Views: 226609

Re: phpBB 3.2 Discussion

I agree to everyone's request that Quick Reply might be the most asked MOD, not just by admins but by users as well. But I personally think it should not be a part of the core system. It takes less than 5 minutes to install one and I think the Quick Reply "feature" would do much better in the hands ...
by Prince of area51
Thu Dec 13, 2007 10:12 pm
Forum: [3.0/Olympus] Discussion
Topic: phpBB 3.2 Discussion
Replies: 257
Views: 226609

Re: phpBB 3.2 Discussion

Cant wait for the feature request to open ;)