MySQL expert

[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!!

[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]

What is the best way for you to look at the table structure?
Should I post the CREATE statements of the tables?

[lnevo]

phpMySQLAdmin if i remember correctly... Thats all the db configuration i know

[Piper]

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]

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