greptilian logo

IRC log for #sourcefu, 2012-12-27

http://sourcefu.com

| Channels | #sourcefu index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary

All times shown according to UTC.

Time S Nick Message
02:08 codex can anyone give me a hand with some sqlite?
02:09 codex I have 2 tables (one for people, and one for 'sent emails')
02:10 codex Every time the people are emailed, i add their IDs to the 'sent emails' table. Trying to do a left join so that if there are 100 people in the 'people' table, and then another 20 are added, only those 20 are added next time to the table
02:11 codex to the table -> to the email table
02:11 codex with ~45,000 records it seems to take 15 minutes which doesn't seem right
02:38 * codex -> palm -> face
02:38 codex turns out sqlite doesn't create indexes automatically
02:39 codex after creating one manually, it went from 18-20 minutes to less than 2 seconds
02:40 semiosis winning
03:28 pdurbin_m joined #sourcefu
03:40 pdurbin_m glad you figured it out
04:11 pdurbin_m Kent Beck on design space https://m.facebook.com/note.php?note_id=510856375613898
15:44 spilth joined #sourcefu

| Channels | #sourcefu index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary

http://sourcefu.com