New topic: Multi-user REALSQLdatabase for Web app ?
<http://forums.realsoftware.com/viewtopic.php?t=41289> Page 1 of 1 [ 5 posts ] Previous topic | Next topic Author Message paxdo Post subject: Multi-user REALSQLdatabase for Web app ?Posted: Thu Nov 03, 2011 7:34 am Joined: Fri Oct 28, 2011 3:42 pm Posts: 3 Hi, What do you think of REALSQLdatabase with multi-user mode (WAL mode - Web app)? Is it reliable? In your opinion, how concurrents access can handle this database? (For a web application) Thank you, olivier Top sonoffreedom Post subject: Re: Multi-user REALSQLdatabase for Web app ?Posted: Thu Nov 03, 2011 8:03 am Joined: Fri Oct 14, 2011 3:08 pm Posts: 68 it is not good that use realSQLDatabase in multi-user it maybe crash when in multi-user status. i recommend MYSQL or postgresSQL. _________________ Love make love,Love IT ------------------------- iMac 510 + Macbook air 234 + Macbook 466 Realstudio 2011R3 i am building a great web project - iOSZone,build by RS Web edition! Top paxdo Post subject: Re: Multi-user REALSQLdatabase for Web app ?Posted: Thu Nov 03, 2011 8:10 am Joined: Fri Oct 28, 2011 3:42 pm Posts: 3 Thank you Sonoffreedom. Yet I have made ââquite a few tests, and it has not crashed and I did not have corrupted data. Please, what was your configuration (number of concurrent users, database size ...) when you had these crashes? Sqlite' People are yet very serious in their tests and reliability of their system. Top sonoffreedom Post subject: Re: Multi-user REALSQLdatabase for Web app ?Posted: Thu Nov 03, 2011 10:13 am Joined: Fri Oct 14, 2011 3:08 pm Posts: 68 paxdo wrote:Thank you Sonoffreedom. Yet I have made ââquite a few tests, and it has not crashed and I did not have corrupted data. Please, what was your configuration (number of concurrent users, database size ...) when you had these crashes? Sqlite' People are yet very serious in their tests and reliability of their system. REALSQLDatabase = SQLITE + single file database, you can write it use larger user in a time (1000 users+) to try _________________ Love make love,Love IT ------------------------- iMac 510 + Macbook air 234 + Macbook 466 Realstudio 2011R3 i am building a great web project - iOSZone,build by RS Web edition! Top paxdo Post subject: Re: Multi-user REALSQLdatabase for Web app ?Posted: Thu Nov 03, 2011 10:47 am Joined: Fri Oct 28, 2011 3:42 pm Posts: 3 Quote:you can write it use larger user in a time (1000 users+) to try 1000 users who write exactly the same time means that there are over 100,000 users. I do not need as much reliability. But I need the database remains reliable with dozens of people who write the same time. With WAL mode, SQLite does not write to the database, but in a separate file (WAL file), so a user who writes can not block readers. It is much more reliable than before. http://www.sqlite.org/wal.html On the SQLite mailing list, a user told me he maintains a web application with several hundred users. But I would like other opinions. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 5 posts ]
-- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
