Page 1 of 1
MySQL expert
Posted: Tue Oct 15, 2013 2:38 pm
by rimai
Hey Guys,
I'd like to know if we have anyone that understand DB, specifically MySQL, and can help out with the way our Portal database is layout out.
I'm getting super low performance and need to figure out a way to improve it.
Thanks!!
Re: MySQL expert
Posted: Tue Oct 15, 2013 2:52 pm
by KRavEN
I might be able to help. Another one of the things I do a lot of is writing big complex queries for reporting as well as designing the database schemas for my web applications. I know mysql, mssql, oracle, and sqlite. I also contributed a lot of code to the php propel orm project to fix mssql pdo support.
Re: MySQL expert
Posted: Tue Oct 15, 2013 2:59 pm
by rimai
What is the best way for you to look at the table structure?
Should I post the CREATE statements of the tables?
Re: MySQL expert
Posted: Tue Oct 15, 2013 5:36 pm
by lnevo
phpMySQLAdmin if i remember correctly... Thats all the db configuration i know
Re: MySQL expert
Posted: Thu Oct 17, 2013 9:35 pm
by Piper
rimai wrote:What is the best way for you to look at the table structure?
Should I post the CREATE statements of the tables?
Post, PM, or e-mail the CREATE statements to me as well. If it's a structure issue I might be able to spot something.
Re: MySQL expert
Posted: Fri Oct 18, 2013 3:48 am
by KRavEN
I think we got the issue worked out through email. He said the performance is greatly improved now.