Advanced Electron Forum Community


Topic : My SQL Optimization


Posted By: aryan on December 16, 2012, 8:16 pm
I am a true lover of aef ...
The main reason ????
Because it has a much better user interface then any other forum app available whether its paid or free .
And if you guys wanna take down VB and IPB then work on its visual part the UI .

It will be much good to use AJAX , Jquery in design .


Let me come on to the point .
I am using aef from more than 4 years on my website and basically forum is what our site is all about .

As the users on my website are 24 K ++ (registered) and even its open to all and we have much more users .

The forum code and queries are not much well optimized ... it consume lots of cpu resources .. and thats the main problem ... my input cost have increased a lot because of this .... The mysql consumes lots of CPU .
I have 4 cored xeon 2.5 GHz processors with 4 GB RAM in a VPS and even thats not enough and its insane ...

You guys really have to work on the quickness part and mysql optimization is required badly ....

-----------------------
we have done some modifications in AEF

Posted By: Sammael on December 18, 2012, 7:47 pm | Post: 1
Really... You should convert to other software. AEF is dead!

Posted By: vendhan on December 31, 2012, 12:02 pm | Post: 2
MySQL is a relational database management system (RDBMS) that runs as a
server providing multi-user access to a number of databases....

Best moving company in Delhi :ICM PacknMove

Posted By: celestia on February 28, 2013, 6:11 am | Post: 3
To optimize the MYSQL we have to follow some tips that will help you to do so:
Proper use of indexes improve performance
Do not perform calculations on an index
“LOAD DATA INFILE” is the fastest way to insert data into MySQL database
Always use EXPLAIN to examine if your select query is efficient
Use caching to reduce database load
Normalize tables to ensure data consistency
Use persistent connections
Don’t use HAVING when you can use WHERE

There may be more but these will help you to improve it.

-----------------------
Web site development services

Powered By AEF 1.1.0 Preview © 2007-2011 AEF Group. All rights reserved