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 > > -- View this message in context: http://old.nabble.com/SQLite---IIS%2C-PHP-and-java-tp27530283p27530753.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