Re: Running Concurrent SQL statements

smpete33@xxxxxxxxx wrote:

> 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.

How many "REAL" CPU's are there on the server?
.

Relevant Pages

  • Re: Running Concurrent SQL statements
    ... they are not long running queries. ... When I run the process twice at the same time, ... sql statements still take the same time to run, ... Prev by Date: ...
    (comp.databases.btrieve)
  • Re: Exporting and Importing SQL Statement Cache
    ... the SQL Statement Cache in Oracle 8i? ... I currently have oracle running on 2 servers and we only use one ... new live server gets overloaded. ... figured this is the sql statements being removed from the sql cache ...
    (comp.databases.oracle.server)
  • Re: DBF (NTX,CDX) JDBC Free Driver
    ... into SQL statements to fill some server and then ... after you fill that server use JDBC.... ... > I'm looking for a free JDBC driver for dbf files using NTX and/or CDX ...
    (comp.lang.java.databases)
  • Re: Exporting and Importing SQL Statement Cache
    ... the SQL Statement Cache in Oracle 8i? ... I currently have oracle running on 2 servers and we only use one ... new live server gets overloaded. ... figured this is the sql statements being removed from the sql cache ...
    (comp.databases.oracle.server)
  • Re: SQL 2005 SP1 Cluster Issue
    ... Yeah the problem is actually running queries via the "new" query analyzer ... management studio to look at table properties and open up dbs using the GUI ... Are you having problem querying the server via a specific client tool? ...
    (microsoft.public.sqlserver.clustering)