I found one open source api for making network interface for any embedded rdbms. The problem was concurrency,for that reason i develop a small thread pool inside the open source network interface and now one rdmbs connection is shared between threads or applications in network. I implement that for SQLite in Java, i hope you can develope some similar net interface. Sending query to interface and and receiveing results from interface in application is builded with tcp sockets and streams.
On 8/24/07, Sreedhar.a <[EMAIL PROTECTED]> wrote: > > I am not using 5 clients from the same machine. > In a network 5 clients and 1 server will be present. > > > Regards, > A.Sreedhar. > > > -----Original Message----- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Friday, August 24, 2007 6:17 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Client/Server approach > > You do not need a server to manage 5 clients on the same machine, only if > they are on a network. > > Sreedhar.a wrote: > > > > Hi, > > > > I am working in sqlite 3.3.6. > > I want 5 clients to browse at the same time with good performance. > > I enabled threadsafe and defined SQLITE_ENABLE_MEMORY_MANAGEMENT . > > I think by using test_server.c we can do 5 clients browsing with > > single server. > > Can any one please help me by providing some patch for implementing > this. > > > > My doubts are: > > 1.Do I need to create a thread for each client.If so it has to be > > created before Sqlite3_server_start(). > > > > (Or) > > Some thing like below has to be followed. > > > > Main() > > { > > > > sqlite3_client_open() > > sqlite3_client_prepare() > > sqlite3_client_step() > > sqlite3_client_reset() > > sqlite3_client_finalize() > > sqlite3_client_close() > > > > Sqlite3_server_start(); For starting the server. > > > > sqlite3_server_stop(); For closing the server. > > > > > > > > } > > > > Kindly help me to solve this. > > Thanks in advance > > > > Best Regards, > > A.Sreedhar. > > > > > > > > > > ---------------------------------------------------------------------- > > ------- To unsubscribe, send email to > > [EMAIL PROTECTED] > > ---------------------------------------------------------------------- > > ------- > > > > > > ---------------------------------------------------------------------------- > - > To unsubscribe, send email to [EMAIL PROTECTED] > > ---------------------------------------------------------------------------- > - > > > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > >