215 reputation
210
bio website ryanzec.com
location Massachusetts
age 29
visits member for 2 years, 7 months
seen Mar 27 at 16:18

A web developer focusing in PHP/MySQL and an inspiring game developer using the Unity game engine.


Jul
22
awarded  Popular Question
Jul
2
awarded  Curious
Apr
25
awarded  Popular Question
Sep
1
awarded  Yearling
Feb
15
revised Naming foreign key columns
deleted 1 characters in body
Feb
15
asked Naming foreign key columns
Feb
14
awarded  Notable Question
Sep
21
awarded  Custodian
Sep
10
awarded  Popular Question
Aug
7
asked Unique combination key MySQL
Jun
15
asked Trying to optimize a MySQL query that has sub selects
Apr
10
comment Trying to optimize query for performance (MySQL)
In all honesty, I should be doing left joins on the ones that allow NULL anyways.
Apr
7
accepted Trying to optimize query for performance (MySQL)
Apr
6
revised Trying to optimize query for performance (MySQL)
edited tags; edited title
Apr
6
reviewed Approve suggested edit on Trying to optimize query for performance (MySQL)
Apr
6
comment Trying to optimize query for performance (MySQL)
it is a MySQL server
Apr
6
comment Trying to optimize query for performance (MySQL)
Better but still around 180-200ms without the order by but if I add the order by, and order by a field on the Issues table, it still takes several seconds (and more times then not, I will have an order by).
Apr
6
comment Trying to optimize query for performance (MySQL)
yea, all the fields that I am joining on have indexes.
Apr
6
revised Trying to optimize query for performance (MySQL)
edited tags; edited title
Apr
6
asked Trying to optimize query for performance (MySQL)