Tomek: I believe the RAM shall cost less than disk because the RAM temp storage is much faster than disk. In case there is a heavy load which make fossil to consume 1 GB disk, when we switch to use RAM, let's assume the RAM accelerate the processes 10 times faster, the server would consume only 100 MB. You see the temporary storage will be released after the transaction.
Am I right? If yes, we might always use the RAM for temporary storage. - Liu Chang 2011/8/23 Tomek Kott <[email protected]> > Richard, > > Am I right that the fossil temporary files (such as _FOSSIL-journal_ or > whatever it is called) are at most twice the size of the check in (i.e., the > size of the checkin for staging and roll back) plus a little overhead? If > so, that means that on a pc with multiple GB of ram, that would be very > little burden, correct? > > Thanks for the clarification! > > Tomek > > > 2011/8/23 Richard Hipp <[email protected]> > >> >> >> 2011/8/23 Liu Chang <[email protected]> >> >>> Hi: >>> >>> when I run fossil with an Apache web server on Windows, it complains the >>> following message when I click on "Files" >>> >> >> The processes run by Apache appear to not be able to locate and/or open >> files in the c:\temp folder. >> >> One possible workaround - recompile Fossil using -DSQLITE_TEMP_STORE=3 >> which will cause Fossil to use RAM for all of its temporary files, rather >> than writing to disk. >> >> >>> >>> ---- >>> >>> SQLITE_CANTOPEN: os_win.c:33680: (5) >>> winOpen(C:\WINDOWS\etilqs_eNlkUH8yb3Zl1PU) - 拒绝访问。(access deny) >>> >>> SQLITE_CANTOPEN: os_win.c:33680: (2) >>> winOpen(C:\WINDOWS\etilqs_Kt1JdjkQhGT5Grj) - 系统找不到指定的文件。 (can not find >>> system file) >>> >>> SQLITE_CANTOPEN: cannot open file at line 33686 of [9b191bb4c7] >>> >>> SQLITE_CANTOPEN: statement aborts at 48: [CREATE TEMP TABLE localfiles(x >>> UNIQUE NOT NULL, u);] unable to open database file >>> Database Error unable to open database file CREATE TEMP TABLE >>> localfiles(x UNIQUE NOT NULL, u); >>> >>> If you have recently updated your fossil executable, you might need to >>> run "fossil all rebuild" to bring the repository schemas up to date. >>> ---- >>> >>> When I click on timeline, it complains: >>> >>> ---- >>> >>> SQLITE_CANTOPEN: os_win.c:33680: (5) >>> winOpen(C:\WINDOWS\etilqs_f946RSzNBHAyFya) - 拒绝访问。 >>> >>> SQLITE_CANTOPEN: os_win.c:33680: (2) >>> winOpen(C:\WINDOWS\etilqs_OLEqQ6kjuA8QmSl) - 系统找不到指定的文件。 >>> >>> SQLITE_CANTOPEN: cannot open file at line 33686 of [9b191bb4c7] >>> >>> SQLITE_CANTOPEN: statement aborts at 37: [CREATE TEMP TABLE IF NOT EXISTS >>> timeline( rid INTEGER PRIMARY KEY, uuid TEXT, timestamp TEXT, comment TEXT, >>> user TEXT, isleaf BOOLEAN, bgcolor TEXT, etype TEXT, taglist TEXT, tagid >>> INTEGER, short TEXT, sortby REAL ) ] unable to open database file >>> Database Error >>> >>> unable to open database file >>> CREATE TEMP TABLE IF NOT EXISTS timeline( >>> rid INTEGER PRIMARY KEY, >>> uuid TEXT, >>> timestamp TEXT, >>> comment TEXT, >>> user TEXT, >>> isleaf BOOLEAN, >>> bgcolor TEXT, >>> >>> >>> >>> >>> etype TEXT, >>> taglist TEXT, >>> tagid INTEGER, >>> short TEXT, >>> sortby REAL >>> ) >>> >>> ---- >>> >>> The Apache is running as a normal user instead of administrator (or system). >>> >>> When I run the apache as an administrator, the problem disappeared. So, the >>> problem should be related to the access priviledge. >>> >>> >>> >>> >>> However, when I run "fossil server" as the same normal user, it works on >>> port 8080 very well. >>> >>> I hope it can be hosted on behind Apache to provide service on port 80, or >>> 443. >>> >>> Thanks, >>> Liu Chang >>> >>> >>> >>> >>> >>> >>> _______________________________________________ >>> fossil-users mailing list >>> [email protected] >>> http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users >>> >>> >> >> >> -- >> D. Richard Hipp >> [email protected] >> >> _______________________________________________ >> fossil-users mailing list >> [email protected] >> http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users >> >> > > _______________________________________________ > fossil-users mailing list > [email protected] > http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users > >
_______________________________________________ fossil-users mailing list [email protected] http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
