04-06-2011
If they're looking at end-user performance issues I'd have the Sybase DBA's check the databases as well. Make sure that they don't need some tuning.
This User Gave Thanks to jtollefson For This Post:
6 More Discussions You Might Find Interesting
1. AIX
Hello everybody.
I have a problem with my AIX 5.3. Recently my unix shows a high cpu utilization with sar or topas.
I need to find what I have to do to solve this problem, in fact, I don't know what is my problem.
I had the same problem with another AIX 5.3 running the same... (2 Replies)
Discussion started by: wilder.mellotto
2 Replies
2. UNIX for Advanced & Expert Users
Hi folks,
I'm running RHEL4 (2.6.9 - 64 bit) on a 4 CPU Dual Core Xeon. This server is running DB2 database. I've been getting the following readings from sar over the past week:
09:35:01 AM cswch/s
09:40:01 AM 4774.95
09:45:01 AM 27342.76
09:50:02 AM 196015.02
09:55:01 AM... (8 Replies)
Discussion started by: fulat2k
8 Replies
3. High Performance Computing
I am interested in setting up some High Performance Computing clusters and would like to get people's views and experiences on this.
I have 2 requirements:
1. Compute clusters to do fast cpu intensive computations
2. Storage clusters of parallel and extendable filesystems spread across many... (6 Replies)
Discussion started by: humbletech99
6 Replies
4. High Performance Computing
Sorry, I am not really from a computer science background. But from the subject of it, does it mean something like multi processor programming? distributed computing? like using erlang? Sound like it, which excite me. I just had a 3 day crash course in erlang and "Cocurrency oriented programming"... (7 Replies)
Discussion started by: linuxpenguin
7 Replies
5. High Performance Computing
hello everyone ,
Im new to HPL. i wanted to know whether High performance linpack solves linear
system of equations for single precision airthmatic on LINUX.
it works for double precision , so is there any HPL version which is for single precision.\
thanks . (0 Replies)
Discussion started by: rahul_viz
0 Replies
6. High Performance Computing
I'm trying to compile Linpack on a Ubuntu cluster. I'm running MPI. I've modified the following values to fit my system TOPdir MPdir LAlib CC LINKER.
When compiling I get the following error: (the error is at the end, the other errors in between are because I've ran the script several times so... (0 Replies)
Discussion started by: JPJPJPJP
0 Replies
LEARN ABOUT PHP
sybase_unbuffered_query
SYBASE_UNBUFFERED_QUERY(3) SYBASE_UNBUFFERED_QUERY(3)
sybase_unbuffered_query - Send a Sybase query and do not block
SYNOPSIS
resource sybase_unbuffered_query (string $query, resource $link_identifier, [bool $store_result])
DESCRIPTION
sybase_unbuffered_query(3) sends a query to the currently active database on the server that's associated with the specified link identi-
fier. If the link identifier isn't specified, the last opened link is assumed. If no link is open, the function tries to establish a link
as if sybase_connect(3) was called, and use it.
Unlike sybase_query(3), sybase_unbuffered_query(3) reads only the first row of the result set. sybase_fetch_array(3) and similar function
read more rows as needed. sybase_data_seek(3) reads up to the target row. The behavior may produce better performance for large result
sets.
sybase_num_rows(3) will only return the correct number of rows if all result sets have been read. To Sybase, the number of rows is not
known and is therefore computed by the client implementation.
Note
If you don't read all of the resultsets prior to executing the next query, PHP will raise a warning and cancel all of the pending
results. To get rid of this, use sybase_free_result(3) which will cancel pending results of an unbuffered query.
PARAMETERS
o $query
-
o $link_identifier
-
o $store_result
- The optional $store_result can be FALSE to indicate the resultsets shouldn't be fetched into memory, thus minimizing memory
usage which is particularly interesting with very large resultsets.
RETURN VALUES
Returns a positive Sybase result identifier on success, or FALSE on error.
EXAMPLES
Example #1
sybase_unbuffered_query(3) example
<?php
$dbh = sybase_connect('SYBASE', '', '');
$q = sybase_unbuffered_query('select firstname, lastname from huge_table', $dbh, false);
sybase_data_seek($q, 10000);
$i = 0;
while ($row = sybase_fetch_row($q)) {
echo $row[0], ' ', $row[1], '<br />';
if ($i++ > 40000) {
break;
}
}
sybase_free_result($q);
sybase_close($dbh);
?>
NOTES
Note
This function is only available when using the CT library interface to Sybase, and not with the DB library.
SEE ALSO
sybase_query(3).
PHP Documentation Group SYBASE_UNBUFFERED_QUERY(3)