Re: [sqlite] Changing file descriptor of database file

2010-05-08 Thread Black, Michael (IS)
@sqlite.org on behalf of Pavel Ivanov Sent: Fri 5/7/2010 3:43 PM To: General Discussion of SQLite Database Subject: [sqlite] Changing file descriptor of database file Hi, all! I'm writing a server application that uses SQLite database as a storage. In fact for various reasons I use a lot of

Re: [sqlite] Changing file descriptor of database file

2010-05-08 Thread Andrew Davison
For people wanting to re-do their networking code I would reccommend Asio (or Boost::Asio), see: http://think-async.com/Asio/ Ad. On 8/05/2010 9:14 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 05/07/2010 01:43 PM, Pavel Ivanov wrote: >> select() has limitat

Re: [sqlite] Changing file descriptor of database file

2010-05-08 Thread Nicolas Williams
On Fri, May 07, 2010 at 05:24:58PM -0400, Mikhail Terekhov wrote: > IMHO it would be better to switch to poll/epoll from select instead of > fighting file descriptor numbers. Better: use libevent. (select()'s limit of 1024 fildes is... odd and derives mainly from the FD*() macros and their semant

Re: [sqlite] Changing file descriptor of database file

2010-05-07 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/07/2010 01:43 PM, Pavel Ivanov wrote: > select() has limitation that it can be used > only with file descriptors less than 1024. This is rarely true and I only know of one crappy operating system that had that limitation 13 years ago. You can s

Re: [sqlite] Changing file descriptor of database file

2010-05-07 Thread Pavel Ivanov
> IMHO it would be better to switch to poll/epoll from select instead of > fighting file descriptor numbers. Sure, that's my opinion too. It's just some significant amount of work which looks like less prioritized at this moment than other application improvements. So I'm looking for some solution

Re: [sqlite] Changing file descriptor of database file

2010-05-07 Thread Mikhail Terekhov
On Fri, May 7, 2010 at 4:43 PM, Pavel Ivanov wrote: > Hi, all! > > I'm writing a server application that uses SQLite database as a > storage. In fact for various reasons I use a lot of SQLite database > files at once. This application can serve hundreds of clients spread > all over the network. C

[sqlite] Changing file descriptor of database file

2010-05-07 Thread Pavel Ivanov
Hi, all! I'm writing a server application that uses SQLite database as a storage. In fact for various reasons I use a lot of SQLite database files at once. This application can serve hundreds of clients spread all over the network. Communication with those clients goes over non-blocking sockets an