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]
-