Re: Running Concurrent SQL statements

No, they are not long running queries. Most take less than 1 second to
run with the longest taking 3 seconds. I have tested this on a server
where this process is the only thing running and I still see the same
problem. When I run the process twice at the same time, the individual
sql statements still take the same time to run, but in whole the whole
process takes longer. That's why it seems Pervasive isn't running more
than one sql statement at a time.

.

Relevant Pages

  • Re: Running Concurrent SQL statements
    ... they are not long running queries. ... > individual sql statements still take the same time to run, ... How many "REAL" CPU's are there on the server? ... Prev by Date: ...
    (comp.databases.btrieve)
  • Re: Help with DELETE Statement
    ... Perfect - Thanks for pointing me in the right direction. ... > That BETWEEN structure can be used with SQL statements, ... >> formatting this incorrectly? ... Prev by Date: ...
    (microsoft.public.fox.helpwanted)
  • Re: Combo boxes that delete
    ... Being that I am pretty new to sql statements I was shocked and amazed ... Thank you so much Doug. ... You rock!!! ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: Performance issue
    ... > The Oracle server version is 9.2.0.4 ... Help just might depend upon the actual SQL statements, ... Do all tables involved have current statistics? ... Prev by Date: ...
    (comp.databases.oracle.server)
  • Re: Help with DELETE Statement
    ... That BETWEEN structure can be used with SQL statements, ... > contains unrecognized phrase/keyword." ... > formatting this incorrectly? ... Prev by Date: ...
    (microsoft.public.fox.helpwanted)