[Genome] please help with large body of queries

[Hiram Clawson]

Good Morning Stanislav:

To work with the data more efficiently, you could download the text dumps of the MySQL
tables and manipulate those files locally with the kent source tree command line tools.
Or load those tables into a local MySQL server and work with them locally.

Or you could work around our data transfer limits and slow down your scripts with
wait commands.

It depends upon  what you are doing.  There may be a more efficient query you could
perform to achieve the same results.  Can you briefly describe the type of measurement
you would like to do ?

--Hiram

Indik Stanislav wrote:
> Dear Madam/Sir, 
> I have received a message referring to a large number of queries accessing your database. I would like to kindly ask you for help. Could you please help me to find more efficient ways to access data in your database (as you suggested in your message, see below). 
> Thank you very much in advance. 
> 
> Sincerely, 
> 
> Stanislav Indik 
> 
> 
> 
> 
> 
> There is a very high volume of traffic coming from your site (IP address 193.171.106.250) as of Fri Aug 17 01:26:51 2007 (California time). So that other users get a fair share of our bandwidth, we are putting in a delay of 10.1 seconds before we service your request. This delay will slowly decrease over a half hour as activity returns to normal. This high volume of traffic is likely due to program-driven rather than interactive access, or the submission of queries on a large number of sequences. If you are making large batch queries, please write to our genome at cse.ucsc.edu public mailing list and inquire about more efficient ways to access our data. If you are sharing an IP address with someone who is sumitting large batch queries, we apologize for the inconvenience. Please contact genome-www at cse.ucsc.edu if you think this delay is being imposed unfairly.
> 
> 
> 
> Stanislav Indik, Ph.D.
> Institute of Virology
> University of Veterinary Medicine Vienna
> Veterinärplatz 1
> A-1210 Vienna
> Austria
> 
> tel: +43 1 250 77-2333
> fax: +43 1 250 77-2690