Again, We have a lot of read/write operation. So, I guess the network latency is problem and think about lock management system.
On Tue, Jan 6, 2009 at 11:23 AM, Edward J. Yoon <edwardy...@apache.org> wrote: > Hi, I'm newbie in here. > > I'm using SQLite, all data (very huge and 20 million files) stored on > NAS storage. Lately my system has been getting progressively slower. > Network cost seems too large. > > To improve its performance, I'm think about local lock file instead of > NAS as describe below. > > char str[1024] = "/tmp"; > strcat(str, lockfile); > sprintf(str, "%s-lock", zFilename); > > But, I'm not sure this is good idea. I would love to hear your advice!! > Thanks. > -- > Best Regards, Edward J. Yoon @ NHN, corp. > edwardy...@apache.org > http://blog.udanax.org > -- Best Regards, Edward J. Yoon @ NHN, corp. edwardy...@apache.org http://blog.udanax.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
