PHP Generator for MySQL Reviews

Dont' waste your time or money

Negative Review by hugolu82
about PHP Generator for MySQL May 2016

Don't waste your time and money on this, I wished I had read reviews like this:
https://blog.velcommuta.de/2014/a-case-study-in-bad-design-php-generator-for-mysql/
and the many other reviews online about this post before ditching out $149, It would have save this money and a lot of time wasted trying to make this product work.
I didn't get to the security problems as it only took a couple of days to realize how BAD the performance of the generated code is. For one single page, the code repeats the same query 13 times, yup 13 times the same query, this is the code taken directly from the tool, and this is not even the query for the actual table, which is repeated twice.
So imagine you have a users table with a decent number of rows and for every page you request, your DB is hit 13 times. It's like putting wooden wheels on your brand new car, you wouldn't do that, would you?

SELECT reg_users.login AS login, reg_users.id AS id FROM reg_users WHERE CAST(reg_users.login AS CHAR) = 'root'
SELECT reg_users.login AS login, reg_users.id AS id FROM reg_users WHERE CAST(reg_users.login AS CHAR) = 'root'
SELECT reg_users.login AS login, reg_users.id AS id FROM reg_users WHERE CAST(reg_users.login AS CHAR) = 'root'
SELECT reg_users.login AS login, reg_users.id AS id FROM reg_users WHERE CAST(reg_users.login AS CHAR) = 'root'
SELECT reg_users.login AS login, reg_users.id AS id FROM reg_users WHERE CAST(reg_users.login AS CHAR) = 'root'
SELECT reg_users.login AS login, reg_users.id AS id FROM reg_users WHERE CAST(reg_users.login AS CHAR) = 'root'
SELECT reg_users.login AS login, reg_users.id AS id FROM reg_users WHERE CAST(reg_users.login AS CHAR) = 'root'
SELECT reg_users.login AS login, reg_users.id AS id FROM reg_users WHERE CAST(reg_users.login AS CHAR) = 'root'
SELECT reg_users.login AS login, reg_users.id AS id FROM reg_users WHERE CAST(reg_users.login AS CHAR) = 'root'
SELECT reg_users.login AS login, reg_users.id AS id FROM reg_users WHERE CAST(reg_users.login AS CHAR) = 'root'
SELECT reg_users.login AS login, reg_users.id AS id FROM reg_users WHERE CAST(reg_users.login AS CHAR) = 'root'
SELECT reg_users.login AS login, reg_users.id AS id FROM reg_users WHERE CAST(reg_users.login AS CHAR) = 'root'
SELECT reg_users.login AS login, reg_users.id AS id FROM reg_users WHERE CAST(reg_users.login AS CHAR) = 'root'

Reply