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 <[email protected]> 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. > [email protected] > http://blog.udanax.org > -- Best Regards, Edward J. Yoon @ NHN, corp. [email protected] http://blog.udanax.org _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
