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

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


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
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
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).
Mar
27
comment Storing Changes To Records
@Eric is will probably vary. some table might be large or update frequently while other are small and update infrequently.