My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 11: sqlite optimization - ускорение create.sh
1 person starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----


 
Reported by vadim.b...@gmail.com, Sep 27, 2011
What steps will reproduce the problem?
1. Запустить create.sh

What is the expected output? What do you see instead?
Генерация базы работает очень медленно.

What version of the product are you using? On what operating system?
svn head @ linux

Please provide any additional information below.

Если строчку: 

sed "$regex" ~tmp.sql | sed "s/\\\'/''/g" > $t.sql;

в create.sh заменить на:

echo "PRAGMA journal_mode = MEMORY;">$t.sql
echo "BEGIN TRANSACTION;" >>$t.sql
sed "$regex" ~tmp.sql | sed "s/\\\'/''/g" >> $t.sql
echo "COMMIT TRANSACTION;" >>$t.sql

То процесс ускоряется во много раз.

Powered by Google Project Hosting