sql - Slow mysql query when additional select criteria added -


i'm having issues sql query going extremely in innodb mysql table. there's 32,000 rows , conditions in clause indexed , either bits or bigints. wouldn't have expected speed issue @ queries take 2 mins complete. it's difficult tell because of caching appears if remove of select criteria query except id query executes in milliseconds.

the rows large store email html row 1mb. when query runs computer uses lot of harddrive resource appears source of speed slowdown. far know though database shouldn't need use additional resource when select criteria added, first finds rows , pulls out information needs rows. can correct me if i'm wrong or let me know if other setting explain behaviour.

as requested here query:

select aplosemail0_.id id4353_, aplosemail0_.active active4353_, aplosemail0_.deletable deletable4353_, aplosemail0_.editable editable4353_, aplosemail0_.persistentdata persiste5_4353_, aplosemail0_.datecreated datecrea6_4353_, aplosemail0_.dateinactivated dateinac7_4353_, aplosemail0_.datelastmodified datelast8_4353_, aplosemail0_.displayid displayid4353_, aplosemail0_.owner_id owner37_4353_, aplosemail0_.useridcreated useridc10_4353_, aplosemail0_.useridinactivated useridi11_4353_, aplosemail0_.useridlastmodified useridl12_4353_, aplosemail0_.parentwebsite_id parentw38_4353_, aplosemail0_.automaticsenddate automat13_4353_, aplosemail0_.emailframe_id emailframe39_4353_, aplosemail0_.emailgenerationtype emailge14_4353_, aplosemail0_.email_generator_type email15_4353_, aplosemail0_.email_generator_id email16_4353_, aplosemail0_.emailreaddate emailre17_4353_, aplosemail0_.emailsentcount emailse18_4353_, aplosemail0_.emailsentdate emailse19_4353_, aplosemail0_.emailstatus emailst20_4353_, aplosemail0_.emailtemplate_id emailte40_4353_, aplosemail0_.emailtype emailtype4353_, aplosemail0_.encryptionsalt encrypt22_4353_, aplosemail0_.forwardedemail_id forward41_4353_, aplosemail0_.fromaddress fromadd23_4353_, aplosemail0_.harddeletedate harddel24_4353_, aplosemail0_.htmlbody htmlbody4353_, aplosemail0_.incomingreadretrycount incomin26_4353_, aplosemail0_.isaskingforreceipt isaskin27_4353_, aplosemail0_.isincomingemaildeleted isincom28_4353_, aplosemail0_.issendingplaintext issendi29_4353_, aplosemail0_.isusingemailsourceasowner isusing30_4353_, aplosemail0_.mailserversettings_id mailser42_4353_, aplosemail0_.maxsendquantity maxsend31_4353_, aplosemail0_.originalemail_id origina43_4353_, aplosemail0_.outeremailframe_id outerem44_4353_, aplosemail0_.plaintextbody plainte32_4353_, aplosemail0_.removeduplicatetoaddresses removed33_4353_, aplosemail0_.repliedemail_id replied45_4353_, aplosemail0_.sendstartidx sendsta34_4353_, aplosemail0_.subject subject4353_, aplosemail0_.uid uid4353_ aplosemail aplosemail0_ aplosemail0_.emailtype=0 , aplosemail0_.emailstatus<>2 , aplosemail0_.mailserversettings_id=7 , aplosemail0_.active=1 order aplosemail0_.id desc limit 50


Comments

Post a Comment

Popular posts from this blog

php - Submit Form Data without Reloading page -

i know question has been asked , answered bunch of times life of me can not solution work on code. believe if redo code, work properly, , in retrospect time i've spent on issue should have redone code...but beyond deadline , have working prototype up... can advise how update multiple forms on single page without reloading page? horrible @ php , complete noob js/jquery/ajax @ best. html/php in single file , believe causing me problems/is largest obstacle @ getting ajax form processing work. basically, want users to: select teams multiple dropdowns in form group 1 (league champs) , on update update db newly selected team without reloadding page. edit team scores per match , on score submit/update, update db new scores. for each requirement there multiple forms (1 each leagues, 1 each per match) have set class on each form id. everything works via php, form submission reloads page each time submitted , not ideal. i have tried ajax code here http://scotch.io/tutoria
Read more

linux - Rails running on virtual machine in Windows -

the reason why want switch ubuntu people said gems works better on linux on windows. i don't want macbook pro rails development since love windows , cannot stand lack of apps mac. moreover, people saying ubuntu "better" mac: http://www.reddit.com/r/ubuntu/comments/1bgj1s/are_there_advantages_of_ubuntu_over_os_x_for/ does virtual box work enough doesn't have lag @ all? using i7-3517u cpu 8gb memory. need program in environment lag-free , not sluggish. or there alternatives recommend? i unsure permission settings or complicated stuffs regarding terminal. i'll using terminal develop. i'm still quite new here development in linux. please kind me >< thanks. @holyxiaoxin pretty sure should asking on superuser instead. nevertheless, suggest install ubuntu in partition instead of running virtual machine. here's guide https://help.ubuntu.com/community/windowsdualboot also, yes. developing in virtual machine accurate, @ end experiment w
Read more

php - $params->set Array between square bracket -

i'm using k2 in joomla 3.3. i'm trying set params (items ids ) module k2_content item.php file. result must between brackets, like: ["96","68"] my code is: $query = "select * #__k2_items extra_fields_search = '$myautor' , catid !=1 " ; $db->setquery($query); $losautores = $db->loadobjectlist(); $result = array(); foreach ($losautores $key => $value) { $result[] = '" '.$value->id.' "'; } $string_version = implode(',', $result); $autoresfinal = '['.$string_version.']'; if test using print, looks ok. passing var pramas, 1064 error. $params->set('items', $autoresfinal); to test tried $autoresfinal = ["96","68"]; and works fine. idea why doesn't work? thank you. if assign ["x","y"] assigning an array . here transforming array in st
Read more