RE: [sqlite] Client/Server approach
Hi,
Yes, The server and clients are in Network.
Best Regards,
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]
-
Re: [sqlite] Client/Server approach
In that case you are best to implement a server on one machine and have
the others connect to it. Since you only have 5 clients you do not need
to use the shared cache approach.
When we use networked clients we use a server with HTTP protocol so that
penetrating firewalls is no problem.
Sreedhar.a 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]
-
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Re: [sqlite] Client/Server approach
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]
>
> -
>
>
RE: [sqlite] Client/Server approach
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]
-
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]
-
