>>> import sqlite3
>>> conn = sqlite3.connect(':memory:')
>>> c = conn.cursor()
>>> c.execute("create table words (word text)")
>>> с.execute("create index word_index on words(word)")
>>> words = ... # загружаем 3млн слов
>>> c.executemany("insert into words values (?)", words_to_insert)
>>>
>>> import dawg
>>> d = dawg.CompletionDAWG(words)
In [31]: %timeit c.execute(u"select 1 from words where word='ВАСЯ'").fetchall()
100000 loops, best of 3: 7.27 us per loop
In [32]: %timeit u'ВАСЯ' in d
1000000 loops, best of 3: 188 ns per loop
In [33]: %timeit c.execute(u'select * from words where word like "ВАСЯ%"').fetchall()
1 loops, best of 3: 720 ms per loop
In [34]: %timeit d.keys(u'ВАСЯ')
100000 loops, best of 3: 12.3 us per loop
STATIC_ROOT = 'C:/Projects/quickstop/quickstop/collected_static/' - норм.
STATIC_URL = '/static/' - норм.
rel=«stylesheet» href="{{ STATIC_URL }}css/style.css" type=«text/css» media=«all»
rel=«stylesheet» href="/static/css/style.css" type=«text/css» media=«all»
urlpatterns += static(settings.STATIC_URL, document_root=settings.MEDIA_ROOT, show_indexes=True)