|Re: [IB-Architect] Interbase connection limit and Support relatedProblems
>Dalton Calford wrote To: IB-Architect@egroups.com<IB-Architect@egroups.com>
>A.) Is this a single server, servicing multiple remote locations (wan) oris
>it only servicing 256+ connections within a single lan?Its a single Sun Solaris Enterprise 450 with 2gigs of Ram. Our clients are
essentially fitness centres throughout
South Africa connected via our Wan. Each club has essentally 5 potential
users sharing a 64K link onto our
>B.) Are some of your connections for information only, ie, a website orpiece
>of equipment that only queries the database?The large number of connections are enquiry based on used very infrequently.
>C.) How many connections does each client application make and whatinterface
>to the database are you using (native/ibx/ibo/bde) (you may need to checkwith
>the people who created your midas package to find out)BDE, this is where the architecture implemented by our developers was wrong.
Each Client could spawn
several connections out of the middle tier.
>D.) Do you have areas in your database where the data can be split intoNot with out a lot of work
>The reason I am asking all this is to find out if load balancing andWe are looking into this at this stage.
>replication may assist you.
the same problems you are now facing, and I have
>spent a year in the redesign of our systems. We are now using lessexpensive
>equipment and getting three times the performance. (under a much heavierload).
Any ideas would be welcome.