|
|
Sponsored Content
Special Forums
IP Networking
Network Tweaking - Database Query Across Internet
Post 302461266 by um08 on Saturday 9th of October 2010 04:53:53 PM
10-09-2010
Network Tweaking - Database Query Across Internet
Hi
We run a script that queries a database via the internet and we need the fast possible connections to the database server.
I have centos server which sends the requests to the database across the internet . it sends upto 800 queries per milliseconds however this using the default settings on our server.
Are their any tweaks we can make to the network card / settings on centos 5.4 ?
I have increased MTU frames to 1500 but thats about it.
Any suggestion would be welcomed
We run a script that queries a database via the internet and we need the fast possible connections to the database server.
I have centos server which sends the requests to the database across the internet . it sends upto 800 queries per milliseconds however this using the default settings on our server.
Are their any tweaks we can make to the network card / settings on centos 5.4 ?
I have increased MTU frames to 1500 but thats about it.
Any suggestion would be welcomed
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi!.
I have problems installing my network card under
ther redhat kernel.
First i tryed my integrated intel pro set 10/100
then my d-link 530tx Pci but none of them seems to
be found.
also i huse my network card to connect to the net
trough PPPOE where i need to type my username and... (3 Replies)
Discussion started by: Gibbler
3 Replies
2. Shell Programming and Scripting
I am executing a SQL query in Unix Server:
select status,location from user_information where request_id='DS-43720'
In shell script I am writing this query in the below manner:
echo "select status,location from user_information where request_id='DS-43720' ;" >> $directory/info.sql
... (3 Replies)
Discussion started by: debu
3 Replies
3. Shell Programming and Scripting
Hi friends,
I have written a script which retrieves one value from the database.
It takes time for the sql query to get the desired output. So the query runs fine from TOAD or from UNIX console.
However if I put this in a script it doesn't work. The script is as below.
#! /bin/ksh... (2 Replies)
Discussion started by: vivek_damodaran
2 Replies
4. Shell Programming and Scripting
Hi,
Am using informix database. When i give "isqlrf <database name> - " from the command prompt , i get connected to the database and i can run sql queries..
I am moving to freeBSD and when i give the same command at the prompt i get an error : Index already exists on column
Why is this... (0 Replies)
Discussion started by: jisha
0 Replies
5. Shell Programming and Scripting
Hi all,
I would want to spool file for a database query, however by using crontab, the file is not spooled. Below shows my script:
ORACLE_HOME="/u01/oraprod/perpdb/10.1.0/db_1"
OUTFILE="/tmp/invalid.out"
FILE="$HOME/admin/scripts"
$ORACLE_HOME/bin/sqlplus -s "/as sysdba"... (0 Replies)
Discussion started by: *Jess*
0 Replies
6. Solaris
i have a router from my isp provider 02. my internet works fine in windows but i am unable to use internet in solaris. when i tried ifconfig command
i was able to see the lo0 which is my laoopback adapter. pls can someone advice. (7 Replies)
Discussion started by: seyiisq
7 Replies
7. IP Networking
Hi! :D
I'm new here, and I will appreciate all the help you can give.
This is the problem we are trying to solve at my office.
At office 1 we have SCO UNIX 5.0.can't remember last number. On it runs database software on which we input/read/modify data throughout terminal software, on remote... (1 Reply)
Discussion started by: PNemesis
1 Replies
8. Programming
How can i modify the below to search for the things i'm looking for during a certain time frame?
select Node, NodeAlias, Summary, Tally, AlertKey, AlertGroup, Manager, Agent from mrtg_alerts where LastOccurrence > '5-Dec-2010' order by Manager desc;
In this particular case, this query is... (3 Replies)
Discussion started by: SkySmart
3 Replies
9. Shell Programming and Scripting
Thank you for taking the time to read my issue. I need to set up a script to run from a wagon wheel type toplogy where 1 server needs to query about 10 to 15 remote servers for duplicate values in a database table. If a duplicate value is found, send an email to me( or wall command to console).... (5 Replies)
Discussion started by: lutador72
5 Replies
10. Programming
I am getting an error function in date formate while importing the date ccolumn in oracle sql developer tool
My date format in table is 6-Nov-14 and while importing its converted to 6/11/14 eventhough the format is as 6-Nov-14 in excel.
could you please let help me out what I need to change... (6 Replies)
Discussion started by: ramkumar15
6 Replies
LEARN ABOUT OSF1
whois
whois(1) General Commands Manual whois(1) NAME
whois - Internet username directory service SYNOPSIS
whois [-h server] name... The whois command looks up user, host, and organization names in the Network Information Center (NIC) database. OPTIONS
Specifies a whois server other than the default server rs.internic.net. DESCRIPTION
The name argument can specify the following: The name of a registered user The name of a registered Internet host The name of some other entity recognized by the whois server By default, the whois command queries the host rs.internic.net. The operands specified to the whois command are concatenated together (separated by white-space) and presented to the whois the server. The default action, unless directed otherwise with a special name is to do a very broad search, looking for matches to name in all types of records and most fields (such as name, nicknames, host name, and network address) in the database. For more information as to what name operands have special meaning, and how to guide the search, use the special name help. EXAMPLES
To display the NIC database entry for the organization osf.org, enter: whois osf.org Open Software Foundation (OSF-DOM) 11 Cambridge Center Cambridge, MAS 02142 Domain Name: OSF.ORG . . . SEE ALSO
DARPA Internet Request for Comment: NICKNAME/WHOIS (RFC 812) whois(1)