Hi,
Maybe use less columns/table if possible. It is possible the client to
share the load with the server ? Some processing can still be done by
the client. Btw, do you measure the system performance (disk access, cpu
load, bla bla bla on the OS). I tried using "hdparm" to increase my disk
access speed on my server and it's help.
hopefully this suggestion will help..
Regards,
Thomas wong
Karla Peralta wrote:
>
>
> Hi,
>
> I have some problems with the perfomance when I run my program
> and I'm just testing in two machines.
>
> I have a diskless system.
>
> This is what I have:
>
> System Configuration:
>
> Server
>
> Architecture : Pentium II
> Memory : 64Mb
> Operating System : RedHat 6.2
> PostgreSQL version : 7.0.3-2
> Compiler used : FlagShip-4.48-7451
> Others : FS2tools-4.48-7451
> SQLkit_PG-1.00
>
>
> Client - Diskless
>
> Memory : 16Mb
> Architecture : Pentium
> Printer : TM930 Paralell Port
>
> My database is 268 Mb, 60 tables, the largest table has about 181659
> rows and 46 columns. I'm using index in each table.
>
> When the program is running it stop for about 15 seconds and then
> continues. I'd like to know what can I do for a better perfomance
> because I need 40 clients machines.
>
> Tell me if you need more information.
>
> Regards,
>
> Karla