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

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


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)
Apr
1
comment Mysql int vs varchar as primary key (InnoDB Storage Engine?
@ypercube So I increase the data to 2 million and the select statement for the int FK get slower exponentially where the varchar foreign key remain pretty steady. A think that the varchar is worth the price in disk/memory requirements for the gain in select queries (which is going to be critical on this particular table and a few others).
Apr
1
asked Foreign key constraints with MySQL/InnoDB
Mar
31
revised Mysql int vs varchar as primary key (InnoDB Storage Engine?
added some tested