MySQL expert

Post Reply
rimai
Posts: 12881
Joined: Fri Mar 18, 2011 6:47 pm

MySQL expert

Post 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!!
Roberto.
KRavEN
Posts: 104
Joined: Sun Mar 17, 2013 8:21 am

Re: MySQL expert

Post 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.
rimai
Posts: 12881
Joined: Fri Mar 18, 2011 6:47 pm

Re: MySQL expert

Post by rimai »

What is the best way for you to look at the table structure?
Should I post the CREATE statements of the tables?
Roberto.
User avatar
lnevo
Posts: 5430
Joined: Fri Jul 20, 2012 9:42 am

Re: MySQL expert

Post by lnevo »

phpMySQLAdmin if i remember correctly... Thats all the db configuration i know :)
Piper
Posts: 296
Joined: Fri Jul 20, 2012 7:13 am
Location: Oakley, CA

Re: MySQL expert

Post 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.
KRavEN
Posts: 104
Joined: Sun Mar 17, 2013 8:21 am

Re: MySQL expert

Post by KRavEN »

I think we got the issue worked out through email. He said the performance is greatly improved now.
Post Reply