[racket] speeding up db.plt loading

From: prad (prad at towardsfreedom.com)
Date: Sun Sep 2 14:50:34 EDT 2012

ryanc's most useful db.plt is what i've mostly used to access sqlite and
postgresql dbs.

however, it tends to take a while to load as far as i can tell possibly
because it is getting stuff for obdc, mysql and postgresql as well as sqlite3
(which is usually the only one i need).

the directory here accessed by (require (planet ryanc/db:1:5)):
~/.racket/planet/300/5.2.1/cache/ryanc/db.plt/1/5
contains the files none of which seem to be very large (main.rkt is only
4.2K and the rest are much smaller).

if i raco my program and run the executable i can get results within 1s,
but running the program through racket can sometimes take nearly 5s
before i see the same results. if i don't load db.plt i get responses
instantly (but of course i have no access to the db).

would just loading sqlite.rkt help?
i couldn't get this to work doing (require (planet ryanc/db:1:5/sqlite))

is there anyway to speed up the loading?

-- 
in friendship,
prad


Posted on the users mailing list.