why is sqlite so slow
1
Name:
Anonymous
2013-08-24 13:31
are all database engines like this?
2
Name:
Anonymous 2013-08-24 13:32
3
Name:
Anonymous
2013-08-25 3:05
is sqlite faster or slower if I commit after every operation? I would have thought it would be faster if I commit since it doesn't need to remember the old state, but it seemed faster for me when I would commit less frequently.
4
Name:
OS 2013-08-25 3:13
>>1
Check your CPU, and processes Son.
5
Name:
Anonymous
2013-08-25 10:29
Time to make the jump to AllegroGraph Web 3.0's database
6
Name:
Anonymous 2013-08-25 10:39
You can make it faster by using transactions.
7
Name:
Anonymous
2013-08-25 13:12
>>3
When you commit it has to flush everything to disk.
8
Name:
Anonymous
2013-08-25 13:46
>>7
FLUSH EVERYTHING FROM MY ANUS
9
Name:
Anonymous 2013-08-25 19:30
there was a bug where every time a post was added the bumptime, numposts, etc, of every existing thread was updated, because silly me forgot the where threadid = threadid clause. Please don't use
>>1 .
10
Name:
Anonymous
2013-08-25 21:11
I fucked up in some language, therefore you should never use that language.
11
Name:
Anonymous 2013-08-25 21:11
12
Name:
Anonymous
2013-08-25 21:23
>>11
Like I said, never use that language, again.
13
Name:
patch 2013-08-25 21:35
14
Name:
>>13 2013-08-25 21:41
the update on post bug is fixed. It doesn't use triggers, but it only updates the thread information after all the posts are written, as opposed to on every post, so that's probably ok. The parser has been modified to ignore closing tags that don't match any previous start tag, and to close tags to get a match. So <span> <p> hello </span> is now accepted. The code size is getting too big to fit in a single post.
15
Name:
>>14 2013-08-25 23:45
sigh... some clever posters found a way to inject invalid unicode sequences into posts. Now I need to make the scraper ignore encodings.
16
Name:
& 2013-08-26 1:32
&
17
Name:
Anonymous
2013-08-26 1:34
Have you considered using pastebin instead of posting the source here?
18
Name:
&& 2013-08-26 1:34
&&
19
Name:
&#& 2013-08-26 1:36
tt
20
Name:
Anonymous 2013-08-26 1:37
tt
21
Name:
2013-08-26 1:38
tt
22
Name:
&@ 2013-08-26 1:39
tt
23
Name:
Anonymous 2013-08-26 1:43
parsing /prog/ is so much harder than I thought it would be...
24
Name:
( 2013-08-26 2:02
tt
25
Name:
&#ff 2013-08-26 2:03
tt
26
Name:
� 2013-08-26 2:03
tt
27
Name:
Anonymous 2013-08-26 2:04
�
28
Name:
Anonymous 2013-08-26 2:04
so that's how you do it...
31
Name:
Anonymous 2013-08-26 3:30
&#bonkers
32
Name:
Anonymous 2013-08-26 3:38
I had to monkey patch python's HTMLParser to get the name in
>>19 to read and recover. It looks like a bug to me.
http://hg.python.org/cpython/file/2.7/Lib/HTMLParser.py#l195
replaced with
33
Name:
Anonymous
2013-09-15 18:01
██████████████████████