| Author |
Message |
    
Littlestar
Pilla Bewarse
Username: Littlestar
Post Number: 176
Registered: 11-2005
Posted From: 76.172.54.225
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, April 12, 2010 - 11:10 pm: |
|
nee sql query ni recycle bin loo padeyi.. |
Gudiwada
Mudiripoyina Bewarse
Username: Gudiwada
Post Number: 4973
Registered: 11-2004
Posted From: 174.100.245.194
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, April 12, 2010 - 7:59 pm: |
|
Fubar:contct nakudu
aadu assala bathikee vunnadu antaava 
Top Tweet of the week : annayya..nenu pfdb hemanth ni...cinema lo comedy kummudu undali annai. 
|
Fubar
Yavvanam Kaatesina Bewarse
Username: Fubar
Post Number: 1521
Registered: 11-2006
Posted From: 74.83.227.89
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, April 12, 2010 - 7:57 pm: |
|
contct nakudu 
B L A H
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 13081
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, April 12, 2010 - 5:45 pm: |
|
trace enable chesa..daniki ekkuva time paduthunda? pattadu emo ga. |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 13075
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, April 12, 2010 - 5:40 pm: |
|
Pda:update statement inka slow avuddi indexes vaditheIf there are too many transactions I would rather drop indexes, update table, and rebuild indexes.
avuna...ante program run ayinappudalla update statement vasthadi...padhaka indexs thesesi pedatham enduku..assala indexes lev anthaku mundu aa table meeda..nenu pettanu. sare entha time padathado chosi thesestha indexes ayithe. |
Pda
Bewarse Legend
Username: Pda
Post Number: 32266
Registered: 06-2006
Posted From: 74.110.17.126
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, April 12, 2010 - 5:38 pm: |
|
update statement inka slow avuddi indexes vadithe If there are too many transactions I would rather drop indexes, update table, and rebuild indexes.
Tough times never last but tough people do.
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 13073
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, April 12, 2010 - 5:36 pm: |
|
program started running from 4:10..almost 26 min..still running. |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 13072
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, April 12, 2010 - 5:36 pm: |
|
created unique index on the table columns too..
after all the modifications running the program. will update you how much time it takes..kani explain plan sarigga ardam kaaledu inka. |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 13071
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, April 12, 2010 - 5:36 pm: |
|
created unique index on the table columns too..
after all the modifications running the program. will update you how much time it takes..kani explain plan sarigga ardam kaaledu inka. |
Don
Celebrity Bewarse
Username: Don
Post Number: 9591
Registered: 12-2004
Posted From: 12.46.64.18
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, April 12, 2010 - 5:35 pm: |
|
Insanity is the inability of the mind to adjust to reality!
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 13068
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, April 12, 2010 - 5:33 pm: |
|
oka update statement 45 mins paduthundi..explain plan gurunchi chadivanu google chesi..plan_table loki vesthundi plan ni..kani adi ela analyse cheyyalo ardam kaaledu..cost, cordinality, bytes etc ela analyse cheyyalo ardam kaaledu..
mundu low data vache join conditions raasi next dani nunchi next condistions ala marchanu query ni....inthaki explain plan ni ela analyse chestharu.. |
Archives-2010