A bit of trivia; I have found that doing
 
Start transaction
     Run the query
Commit the transaction
Start transaction
     Run the query
Commit the transaction
Start transaction
     Run the query
Commit the transaction
.....

really sucks reources... and takes an eternity to complete.
 
Cheers,
Dion

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Thursday, May 02, 2002 7:34 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Problem


At 06:04 PM 02-05-02 -0300, Vinicius wrote:

>I am using FIB super server V1.0
>
>With one computer reading data from the database server.
>( My server is a Windows 2000 professional - P4 1.5 Ghz 512 RAM AND a
>another server is a Linux Red Hat 7.2 K6 2 - 500 Mhz with 64 MB ram )
>
>My problem is :
>
>At 5 and 5 seconds I close and open one query that read data from one

table,

>after some  minutes that my program is running at this form just doing this
>query the program start to report a error with this message :
>
>"Too many concurrent executions of the same request"
>
>Why, I don't really believe what I see...

At 5-second intervals, you are doing this?
Start transaction
    Run the query
      Start transaction
         Run the query
           Start transaction
             Run the query
                ......
Eventually, something is going to break.

You need:
Start transaction
     Run the query
Commit the transaction
Start transaction
     Run the query
Commit the transaction
Start transaction
     Run the query
Commit the transaction
.....

More information would be useful.

Also, please post ONE question to ONE list.  So far today I have counted
four instances of the same question in three lists.  As all of your
questions are support questions, they belong HERE, not in IB-Architect or
firebird-devel.

Helen

All for Open and Open for All
Firebird Open SQL Database · HYPERLINK
"http://firebirdsql.org"http://firebirdsql.org ·
HYPERLINK "http://users.tpg.com.au/helebor/"http://users.tpg.com.au/helebor/
_______________________________________________________



Yahoo! Groups Sponsor
ADVERTISEMENT
HYPERLINK
"http://rd.yahoo.com/M=226014.2032696.3508022.1829184/D=egroupweb/S=17051153
86:HM/A=1000239/R=0/*http://ads.x10.com/?bHlhaG9vaG0xLmRhd=1020393814%3eM=22
6014.2032696.3508022.1829184/D=egroupweb/S=1705115386:HM/A=1000239/R=1"
HYPERLINK
"http://us.adserver.yahoo.com/l?M=226014.2032696.3508022.1829184/D=egroupmai
l/S=1705115386:HM/A=1000239/rand=307319604"

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the HYPERLINK
"http://docs.yahoo.com/info/terms/"Yahoo! Terms of Service.



---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.342 / Virus Database: 189 - Release Date: 03/14/2002



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.342 / Virus Database: 189 - Release Date: 03/14/2002



[Non-text portions of this message have been removed]