[Brahms-dev-l] Re: strange mysql use

Ok.  Looking more carefully (a few minutes), you (BrFileCatalogInfo???)  
was doing the following query.

"SELECT * FROM DataVersion WHERE ProductionVerId = 30 and RunNo = 13899"

Now, the content of this table (DataVersion) is the following.
+-----------------+-------------+------+-----+---------+----------------+
| Field           | Type        | Null | Key | Default | Extra          |
+-----------------+-------------+------+-----+---------+----------------+
| VersionId       | int(11)     |      | PRI | NULL    | auto_increment |
| VersionNo       | int(11)     |      |     | 0       |                |
| DataTypeId      | int(11)     |      |     | 0       |                |
| InputVerId      | int(11)     |      |     | 0       |                |
| BratVer         | varchar(15) |      |     |         |                |
| RootVer         | varchar(15) |      |     |         |                |
| Script          | text        |      |     |         |                |
| Creator         | varchar(30) |      |     |         |                |
| Comments        | text        | YES  |     | NULL    |                |
| RunNo           | int(11)     | YES  |     | NULL    |                |
| ProductionVerId | int(11)     |      |     | 0       |                |
+-----------------+-------------+------+-----+---------+----------------+

Now, from the above query, you don't need to get all data from this 
table.  Particularly, you don't need to get "Script, Creator, Comments, 
BratVer, RootVer". Since you are tring to get all (by Select * from 
DataVersion), this might be the reason for slowness.   After glacing at 
BrFileCatalogXXX codes, I did not see this particular command.  Someone 
who wrote this code can check this and modify the code???

Hiro


Truls Martin Larsen wrote:

>Hi,
>
>This is the code in banapp... It uses the BrFileCalalogManager, no
>custom query stuff. The idea is to give dst2tre a run range, begin run
>and end run number, and then the code retrives the location of the dsts
>that exist file catalog for given version and production, ie it just a
>loop from begin run number to end run number...
>
>So if I understand correctly:
>
>1. Init FileCatalog manager.
>2. Register runs
>3. call filecatalog update
>4 retive the filcatalog run.
>
>How can one do this i a proper way, without loading the DB to much??? 
>
>Cheers,
>	Truls
>
>On Thu, 2006-02-02 at 09:16 -0500, Hironori Ito wrote:
>  
>
>>Hello, Truls.  Are you querying FILECATALOG with some strange way in 
>>your own program?  MySQL server is having tough time querying your 
>>request.  If you are using your own query command, I suggest you ( as 
>>well as any other person who use own SQL command for query) to check if 
>>you can decrease the load to MySQL server.  Otherwise, the server 
>>response is too slow for other person.
>>
>>Hiro
>>
>>    
>>

_______________________________________________
Brahms-dev-l mailing list
Brahms-dev-l@lists.bnl.gov
http://lists.bnl.gov/mailman/listinfo/brahms-dev-l