132 reputation
26
bio website
location
age
visits member for 1 year, 10 months
seen Jul 5 '13 at 6:45

Aug
4
awarded  Notable Question
May
26
awarded  Popular Question
Oct
12
awarded  Notable Question
Jul
4
comment “Mysql has gone away” heavy multiple insert
@RolandoMySQLDBA Rolando, what happens when this is not related to to the max_allowed_packet size? I've increased my to 1G and still my server crashes after the 2nd iteration of the loop. None of my fields contain more than about 50 characters, and my tables have no more than 3 columns and 1 join. However some of my inserts contain 50 thousand rows, and this cannot be split up. How would one deal with that?
Jul
4
accepted How can I better optimize my tables and a LEFT JOIN query to find items that don't yet exist in the right table?
Jul
3
comment How can I better optimize my tables and a LEFT JOIN query to find items that don't yet exist in the right table?
no, and I'm not quite sure how and when to index. Mysql suggests not being over anxious and creating indexes on all columns. But in one query or another throughout this application, each one of those columns in wordlocation is heavily used in where clauses. For now though, how would I add an index and on which column? I'm sure that can at least get me started and I can provide some better feedback
Jul
3
asked How can I better optimize my tables and a LEFT JOIN query to find items that don't yet exist in the right table?
Jul
1
accepted How do I select items from a table where a single column must contain two (or more) values?
Jul
1
comment How do I select items from a table where a single column must contain two (or more) values?
Fantastic! Thanks so much! I will indeed enjoy testing them. For that first query with the having clause, does that number change to match the number of items in where where in clause? So here it's 3; if someone queried with 2 words or 10 words, then the having count(*) clause would equal 2 or 10 respectively?
Jul
1
comment How do I select items from a table where a single column must contain two (or more) values?
@a_horse_with_no_name I found this link stackoverflow.com/questions/15114581/… where the answer has 'having count(*) = 3' in the query. This is similar to my where in clause above, but it's the results are different. Do you know why this clause is there or why it's affecting the results?
Jul
1
revised How do I select items from a table where a single column must contain two (or more) values?
added more information
Jul
1
comment How do I select items from a table where a single column must contain two (or more) values?
@ypercube honestly, I am not quite sure, but my gut tells me that 'wordid' in this table is unique. There is another table that contains 'docid, wordid, wordlocation' where the wordlocation is the position of the word in the text. Maybe this will shed some light on the topic for you, for anyone, who would like to know where this is going: my.safaribooksonline.com/book/web-development/9780596529321/… I'm trying to reproduce this code in PHP / MYSQL but I'm not sure how to recreate the SQL statement.
Jul
1
comment How do I select items from a table where a single column must contain two (or more) values?
@ypercube no, there is no unique constraint. A document (docid) can have any number of words. Each word in the document is represented by its wordid. Basically, it's an index of what words appear in what documents. If a document had 100 words, then its id would appear 100 times in this database.
Jul
1
awarded  Editor
Jul
1
comment How do I select items from a table where a single column must contain two (or more) values?
@ypercube sorry, thanks for catching that. My question was completely wrong. Please reread.
Jul
1
revised How do I select items from a table where a single column must contain two (or more) values?
grave error in understating of topic. rewrote the question
Jul
1
asked How do I select items from a table where a single column must contain two (or more) values?
Apr
9
awarded  Popular Question
Oct
10
awarded  Supporter
Oct
10
awarded  Scholar