172 reputation
6
bio website legoservices.com
location Altoona, PA
age 28
visits member for 2 years, 9 months
seen Apr 6 '13 at 3:06

Jun
4
awarded  Teacher
Apr
30
accepted Does MVC architecture design pattern effect MySQL database performance?
Mar
18
accepted Is there a reason/benefit I am not aware of for this kind setup?
Mar
16
awarded  Commentator
Mar
16
comment Is there a reason/benefit I am not aware of for this kind setup?
@MartinSmith I have no idea ..
Mar
16
comment Is there a reason/benefit I am not aware of for this kind setup?
I think that transactions even if rolled back still increment the id by 1, but we don't have anything that would need to be that strict in the database. Maybe he was moving in that direction though for other systems that where planned.
Mar
16
asked Is there a reason/benefit I am not aware of for this kind setup?
Feb
20
comment Does MVC architecture design pattern effect MySQL database performance?
@RolandoMySQLDBA Config added
Feb
20
revised Does MVC architecture design pattern effect MySQL database performance?
Added my.cnf
Feb
19
comment Need to find duplicate entries
I deleted my answer - I can't come up with the query that will update your child tables foreign keys based on the duplicate-removed recipe tables new primary ids. You could set the constraints to cascade, but you will loose comments for duplicates that are removed in the recipe table.
Feb
19
comment How to recover previous values in Mysql Table?
Hopefully you have a backup - if you don't control the backups your gonna have to talk to someone that does sometime soon incase your backups over write themselves. I think you may be able to look at a log file for changes made - but I could be wrong about that.
Feb
18
comment Does MVC architecture design pattern effect MySQL database performance?
I just read something similar in the book high performance for mysql explaining about relationship queries and how these frameworks can cause bottlenecks with mysql. Thanks.
Feb
18
answered How do I model data from arbitrary CSV's in a database?
Feb
17
comment Does MVC architecture design pattern effect MySQL database performance?
@RolandoMySQLDBA I am not the webmaster for the site - just trying to help trouble shoot the issue. The webmaster sent a request to the host for the my.cnf file - as soon as I receive it I will post. Thanks.
Feb
17
asked Does MVC architecture design pattern effect MySQL database performance?
Nov
28
awarded  Supporter
Nov
28
awarded  Scholar
Nov
28
accepted MySQL 5.5 InnoDB = OFF?
Nov
28
awarded  Student
Nov
28
asked MySQL 5.5 InnoDB = OFF?