Thanks Martin, alexis
Martin Engelschalk wrote: > > Hi Alexis, > > you will be ok. However, make sure to handle the SQLITE_BUSY returncode > in your apps correctly, and keep the write-transactions short and commit > or rollbackt them all. Based on your data, a SQLITE_BUSY will be very > unlikely, but you have to take it into account. > > See also http://www.sqlite.org/c3ref/busy_timeout.html > > To answer your question: Yes, sqlite will insure sequestial write by > using its locking nechanism. If there are many write operations however, > the database will be locked often and other applications will be forced > to wait for longer and longer times, which can become unaccepable to the > people using you web application. > > Martin > > alexis_ wrote: >> Hi Martin >> >> The Java Application will do all the write. PHP will only read. (Just out >> of >> curiosity what would the implication be if both PHP and Java did write. >> Wouldn’t SQLite insure sequential write?) >> >> As for Traffic: >> Java could do 1 or 2 write's once a day. >> PHP will be doing 2000 - 4000 reads a day. Mostly in the morning around >> 08:30 and afternoon 17:00 >> >> Cheers >> Alexis >> >> >> Martin Engelschalk wrote: >> >>> Hi, >>> >>> the important question is: What about updates to the database? Will >>> there be concurrent updates, or will the db be read only? Will some >>> processes read an others write? What amount of traffic do you expect on >>> the site? >>> >>> See http://www.sqlite.org/faq.html#q5 >>> >>> Martin >>> >>> alexis_ wrote: >>> >>>> Hi there, >>>> >>>> I am at the research stage of a project i have been asked to undertake. >>>> >>>> At the moment the O/S will be windows server 2003 and the web server >>>> IIS. >>>> These are set and i cannot change them. >>>> >>>> I will be using PHP to deliver the web content to users and also a Java >>>> application will be used to integrate to third party product. >>>> >>>> Both PHP and Java will be accessing a SQLite db concurrently. SQLite, >>>> Java >>>> App and php will all be on one box. So my questing is should this setup >>>> work >>>> OK? Is there anything i should be aware off. >>>> >>>> Thank you for any help, pointers >>>> >>>> Alexis >>>> >>>> >>>> >>>> >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >>> >>> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/SQLite---IIS%2C-PHP-and-java-tp27530283p27531096.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
