learn linux and unix commands - unix shell scripting

Improve PHP Performance by Caching Database Results

9 More Discussions You Might Find Interesting

1. Programming

Improve the performance of my C++ code

Hello, Attached is my very simple C++ code to remove any substrings (DNA sequence) of each other, i.e. any redundant sequence is removed to get unique sequences. Similar to sort | uniq command except there is reverse-complementary for DNA sequence. The program runs well with small dataset, but...

2. UNIX for Dummies Questions & Answers

How to improve the performance of this script?

Hi , i wrote a script to convert dates to the formate i want .it works fine but the conversion is tkaing lot of time . Can some one help me tweek this script #!/bin/bash file=$1 ofile=$2 cp $file $ofile mydates=$(grep -Po '+/+/+' $ofile) # gets 8/1/13 mydates=$(echo "$mydates" | sort |...

3. Shell Programming and Scripting

Improve performance of echo |awk

Hi, I have a script which looks like this. Input file data1^20 data2^30 #!/bin/sh file"/home/Test.txt" while read line do echo $line |awk 'BEGIN { FS = "^" } ; { print $2 }' echo $line |awk 'BEGIN { FS = "^" } ; { print $1 }' | gzip | wc -c done <"$file" How can i...

4. Programming

Help with improve the performance of grep

Input file: #content_1 12314345345 242467 #content_14 436677645 576577657 #content_100 3425546 56 #content_12 243254546 1232454 . . Reference file: content_100

5. Shell Programming and Scripting

Want to improve the performance of script

Hi All, I have written a script as follows which is taking lot of time in executing/searching only 3500 records taken as input from one file in log file of 12 GB Approximately. Working of script is read the csv file as an input having 2 arguments which are transaction_id,mobile_number and search...

6. Shell Programming and Scripting

Any way to improve performance of this script

I have a data file of 2 gig I need to do all these, but its taking hours, any where i can improve performance, thanks a lot #!/usr/bin/ksh echo TIMESTAMP="$(date +'_%y-%m-%d.%H-%M-%S')" function showHelp { cat << EOF >&2 syntax extreme.sh FILENAME Specify filename to parse EOF...

7. UNIX for Dummies Questions & Answers

Improve Performance

hi someone tell me which ways i can improve disk I/O and system process performance.kindly refer some commands so i can do it on my test machine.thanks, Mazhar

8. Shell Programming and Scripting

How to improve grep performance...

Hi All, I am using grep command to find string "abc" in one file . content of file is *********** abc = xyz def= lmn ************ i have given the below mentioned command to redirect the output to tmp file grep abc file | sort -u | awk '{print #3}' > out_file Then i am searching...

9. UNIX for Advanced & Expert Users

improve performance by using ls better than find

Hi , i'm searching for files over many Aix servers with rsh command using this request : find /dir1 -name '*.' -exec ls {} \; and then count them with "wc" but i would improve this search because it's too long and replace directly find with ls command but "ls *. " doesn't work. and...

LEARN ABOUT PHP

sqlsrv_connect

SQLSRV_CONNECT(3)														 SQLSRV_CONNECT(3)

sqlsrv_connect - Opens a connection to a Microsoft SQL Server database

SYNOPSIS

       resource sqlsrv_connect (string	$serverName, [array  $connectionInfo])

DESCRIPTION

	Opens  a  connection  to a Microsoft SQL Server database. By default, the connection is attempted using Windows Authentication. To connect
       using SQL Server Authentication, include "UID" and "PWD" in the connection options array.

PARAMETERS

	      o $serverName
		- The name of the server to which a connection is established. To connect to a specific instance, follow the server  name  with  a
		forward slash and the instance name (e.g. serverNamesqlexpress).

	      o $connectionInfo
		-  An associative array that specifies options for connecting to the server. If values for the UID and PWD keys are not specified,
		the connection will be attempted using Windows Authentication. For a complete  list  of  supported  keys,  see	SQLSRV	Connection
		Options.

RETURN VALUES

	A connection resource. If a connection cannot be successfully opened, FALSE is returned.

EXAMPLES

       Example #1

	      Connect using Windows Authentication.

	      <?php
	      $serverName = "serverNamesqlexpress"; //serverNameinstanceName

	      // Since UID and PWD are not specified in the $connectionInfo array,
	      // The connection will be attempted using Windows Authentication.
	      $connectionInfo = array( "Database"=>"dbName");
	      $conn = sqlsrv_connect( $serverName, $connectionInfo);

	      if( $conn ) {
		   echo "Connection established.<br />";
	      }else{
		   echo "Connection could not be established.<br />";
		   die( print_r( sqlsrv_errors(), true));
	      }
	      ?>

       Example #2

	      Connect by specifying a user name and password.

	      <?php
	      $serverName = "serverNamesqlexpress"; //serverNameinstanceName
	      $connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
	      $conn = sqlsrv_connect( $serverName, $connectionInfo);

	      if( $conn ) {
		   echo "Connection established.<br />";
	      }else{
		   echo "Connection could not be established.<br />";
		   die( print_r( sqlsrv_errors(), true));
	      }
	      ?>

       Example #3

	      Connect on a specifed port.

	      <?php
	      $serverName = "serverNamesqlexpress, 1542"; //serverNameinstanceName, portNumber (default is 1433)
	      $connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
	      $conn = sqlsrv_connect( $serverName, $connectionInfo);

	      if( $conn ) {
		   echo "Connection established.<br />";
	      }else{
		   echo "Connection could not be established.<br />";
		   die( print_r( sqlsrv_errors(), true));
	      }
	      ?>

NOTES

	By  default, the sqlsrv_connect(3) uses connection pooling to improve connection performance. To turn off connection pooling (i.e. force a
       new connection on each call), set the "ConnectionPooling" option in the $connectionOptions array to 0 (or FALSE). For more information, see
       SQLSRV Connection Pooling.

	The  SQLSRV  extension does not have a dedicated function for changing which database is connected to. The target database is specified in
       the $connectionOptions array that is passed to sqlsrv_connect. To change the database on an open connection, execute  the  following  query
       "USE dbName" (e.g. sqlsrv_query($conn, "USE dbName")).

SEE ALSO

       sqlsrv_close(3), sqlsrv_errors(3), sqlsrv_query(3).

PHP Documentation Group 													 SQLSRV_CONNECT(3)