Welcome Guest. Please Login or Register  


You are here: Index > Advanced Electron Forums > Development > Topic : My SQL Optimization


News:

Group Message
Hello Guest,

Welcome to the AEF Board. AEF is getting better and better and is also becoming more popular.
Take a few seconds to Register, its free, and it inspires us to work harder and improve on whatever we can improve on.
Give us some feedback, and tell your buddies about AEF!

Thanks,
The AEF Team



Threaded Mode | Print  

 My SQL Optimization (3 Replies, Read 48098 times)
aryan
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
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
IP: --   

My SQL Optimization
Sammael
Group: Member
Post Group: Newbie
Posts: 37
Status:
Really... You should convert to other software. AEF is dead!
IP: --   

My SQL Optimization
vendhan
Group: Member
Post Group: Newbie
Posts: 1
Status:
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
IP: --   

My SQL Optimization
celestia
Group: Member
Post Group: Newbie
Posts: 1
Status:
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
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Members who read this topic
aryan, VasiliyRS, thomaswinter, Sammael, tushar897, vendhan, antros, celestia


Users viewing this topic
2 guests, 0 users.


All times are GMT. The time now is December 13, 2017, 3:27 pm.

  Powered By AEF 1.1.0 Preview © 2007-2011 AEF Group. All rights reservedQueries: 13  |  Page Created In:0.055