Michael Frey

Finland

namibsoft.com

Age: 33

Student programmer.
May
21
comment Performance issue on MySql join where value between 2 columns
@AbhikChakraborty There is an index on ip_address, but I think it is not relevant to the query, because the column is the source against which the other table is matched. I assume there is an issue in how the second table is matched. Since there are thousands of rows that match bigger than and also smaller than criteria, and until that is filtered down to just one row takes a long time. But I don't know how to fix this.
May
21
comment Performance issue on MySql join where value between 2 columns
@AbhikChakraborty Explain results are now part of the question.
May
21
revised Performance issue on MySql join where value between 2 columns
added 338 characters in body
May
21
comment Performance issue on MySql join where value between 2 columns
@AbhikChakraborty Thanks, but they are all indexed. Still takes around 5 minutes.
May
21
comment Performance issue on MySql join where value between 2 columns
@AbhikChakraborty It just tells me that both are simple queries and how many rows there are per table. The ipaddress table is quite large obviously. Containing some 140k entries.
May
21
asked Performance issue on MySql join where value between 2 columns
Mar
8
awarded Notable Question
Dec
30
awarded Yearling
Dec
29
awarded Yearling
Nov
19
awarded Yearling
Nov
19
awarded Autobiographer
Oct
16
awarded Famous Question
Sep
1
awarded Nice Question
Aug
1
accepted MySql query returning entire table with possible values from a second table
Aug
1
comment MySql query returning entire table with possible values from a second table
@jbrosi Was just looking at your jsfiddle as well. It only works with the id 1223. Another id skips some results.
Aug
1
comment MySql query returning entire table with possible values from a second table
I was unaware that it is possible to do an additional AND statement with a join statement. Also, interestingly replacing on uec.event_category_id = ec.event_category_id with USING(event_category_id) does not work.
Aug
1
comment MySql query returning entire table with possible values from a second table
Thanks for the answer, but this only returns the category where the users are linked to, and excludes all others.
Aug
1
accepted Structuring Modules and socket.io in node.js
Aug
1
asked MySql query returning entire table with possible values from a second table
Jul
26
comment Structuring Modules and socket.io in node.js
This looks like what I want. How would I handle a module though that requires several sockets? I assume create the object first and then simply use an addSocket function.
1 2 3 4 5