| Author |
Message |
    
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 750
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:24 pm: |
|
Gochi:
nope for example
mary ani undi anukoo
mar isthee mar tho vchee results ani kavaalanataa..
ilemaa report genrate chesukovochugaa.. ala desgn sesaru page nii |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 78654
Registered: 07-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:20 pm: |
|
aina query lo like @firstname + '%' ani endukettaaru...is it like they are concatenating % to what they are passing from front end.. |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 749
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:20 pm: |
|
Firefox:
tried ..not working..
Contains use chesaa where caluse lo ..
\problem entante it would ftech in a paragraph text ..rather than jusr name search |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 748
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:19 pm: |
|
Gotcha:
indexes craeet chesanu annay |
Gotcha
Pilla Bewarse
Username: Gotcha
Post Number: 485
Registered: 01-2007
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:15 pm: |
|
if that didn't help, since last name is unique, apply even that to composite index you created before with 3 columns and see. |
Firefox
Pilla Bewarse
Username: Firefox
Post Number: 771
Registered: 12-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:13 pm: |
|
edo full text search anta with -
CONTAINS or FREETEXT
Comparing LIKE to Full-Text Search
In contrast to full-text search, the LIKE Transact-SQL predicate works on character patterns only. Also, you cannot use the LIKE predicate to query formatted binary data. Furthermore, a LIKE query against a large amount of unstructured text data is much slower than an equivalent full-text query against the same data. A LIKE query against millions of rows of text data can take minutes to return; whereas a full-text query can take only seconds or less against the same data, depending on the number of rows that are returned.
http://msdn.microsoft.com/en-us/library/ms142571.aspx |
Gotcha
Pilla Bewarse
Username: Gotcha
Post Number: 484
Registered: 01-2007
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:10 pm: |
|
create a composite index with these three columns and see
pro.default_location
pro.org_id
completed_indicator |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 747
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:10 pm: |
|
query leepsaa |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 746
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:10 pm: |
|
Gotcha:
yes..again where clause is applied to view.. we will get reuslts which we dont want ..edi think sesina idea vachi savataledhu |
Gotcha
Pilla Bewarse
Username: Gotcha
Post Number: 483
Registered: 01-2007
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:05 pm: |
|
indexed view is not the solution. if your table is indexed your view results will be same as your table scan results. |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 745
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:05 pm: |
|
Gotcha:
adi antha sesakee... Like seraches are killing ani conclusion kochaa u r honor |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 744
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:05 pm: |
|
Godfather:
Anni sesanu annay..
daniki like tesey ..ventane result vastahdi antee like kavalantandii .. ayithe dobichukoo ani sepdamanukuntunaa//sava thenksiyoo ilemaaa |
Gotcha
Pilla Bewarse
Username: Gotcha
Post Number: 482
Registered: 01-2007
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:04 pm: |
|
first make sure all these columns are indexed:
pro.first_Name
pro.last_name
pro.default_location
pro.org_id
Second,
Run the queries individually without join and see how long it takes. |
Godfather
Bewarse Legend
Username: Godfather
Post Number: 68013
Registered: 03-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:04 pm: |
|
Query analyzer use sessi soodu emana help avutundi emo.. |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 743
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 3:00 pm: |
|
Nalla_baalu:
anthaka mundu 180 lines undi..nenu dani e range ki tesukochaaa ..
ayyinaa musaladi sava thenkuthundii ..anthaka mund 20 mins run ayedi ippudu 5 mins..daniki 1 sec lomkavalaantaaa |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 742
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:59 pm: |
|
Godfather:
Indexed View would be faster..
kaani limitations unte seppu |
Nalla_baalu
Yavvanam Kaatesina Bewarse
Username: Nalla_baalu
Post Number: 8795
Registered: 06-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:59 pm: |
|
endadhi query naaa developing ki ichina code aaa
Aug 11th weight -- 84 kg \bemmi.muniga icon
|
Godfather
Bewarse Legend
Username: Godfather
Post Number: 68012
Registered: 03-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:56 pm: |
|
Yea indexed view annee.. Normal view aite peddaga help vundadu.. |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 741
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:54 pm: |
|
annay like columns are killing i am sure |
Gotcha
Pilla Bewarse
Username: Gotcha
Post Number: 481
Registered: 01-2007
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:49 pm: |
|
while joining the results to another table use the pk column.
No way the search will be 5 minutes if it is just a simple table with 2 million and column is indexed.
now you are saying there is a join, so aa logic kuda post, idea cheputa. it must be the join which is causing the issue |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 739
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:48 pm: |
|
Godfather:
view inka slow kadehee .. ?indexed view mind lo undi..but datawarehousing vadathanu adi..adi ela pani setahdoo telidu |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 738
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:48 pm: |
|
Ma company co director anta sava thenkuthundi..musali mndaaa ..i want asap antadi..  |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 737
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:47 pm: |
|
Gotcha:
pk is an ident column. but the search is on name .. and results are joined to other table .. thats having another million recoerds |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 736
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:46 pm: |
|
Gotcha:
yes indxed..covering index add chesanu.. |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 735
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:46 pm: |
|
Gochi:
I am sure its beacuse of like |
Gotcha
Pilla Bewarse
Username: Gotcha
Post Number: 480
Registered: 01-2007
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:45 pm: |
|
your search will be faster if there is primary key or other indexed column in your search. what is the primary key of this table? |
Gotcha
Pilla Bewarse
Username: Gotcha
Post Number: 479
Registered: 01-2007
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:43 pm: |
|
is first name column indexed? |
Godfather
Bewarse Legend
Username: Godfather
Post Number: 68011
Registered: 03-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:42 pm: |
|
Essay type setta vundu.. |
Godfather
Bewarse Legend
Username: Godfather
Post Number: 68010
Registered: 03-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:40 pm: |
|
Direct table meeda query kante.. View create chesi try cheyi.. |
Nalla_baalu
Yavvanam Kaatesina Bewarse
Username: Nalla_baalu
Post Number: 8794
Registered: 06-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:40 pm: |
|
Godfather:Joins vunnaya or else single table?
rendu cases lo emaithaayo cheppandi for furture reference
Aug 11th weight -- 84 kg \bemmi.muniga icon
|
Godfather
Bewarse Legend
Username: Godfather
Post Number: 68009
Registered: 03-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:33 pm: |
|
Joins vunnaya or else single table? |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 78653
Registered: 07-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:26 pm: |
|
Lenevo:gochi annay .. main aim is to restrict table/index scan .. from lo nuvvu chepiantu chesina like wll do all the search
true...but I just want to confirm if this like is what is killing the whole thing...ippudu subquery lo raasukuni kooda work avvakapothe then we are 100% sure its because of this...lekapothe it can be 100 different reasons kadhaa ani...the way other indexes are working etc
ippudu like ki choodaam em cheyyaalo |
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 22111
Registered: 06-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:26 pm: |
|
Nalla_baalu:annai movers dhi oka manchi suggestion ivvandi ...austin to minneapolis moving friends telisina vaalu
naaku peddaga theledu kani oka friend NC nunchi dallas move ayyadu. 900 ani chivaraki 1300 ala chesadu anta bill. it is excluding car. inti samanu. sofa, beds etc ki. athanu ippudu sleep lo undi untadu. evening call chesi cheptha. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 78652
Registered: 07-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:25 pm: |
|
Lenevo:this is in sql server basically
SQL Server anta bemmam baa |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 734
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:24 pm: |
|
gochi annay .. main aim is to restrict table/index scan .. from lo nuvvu chepiantu chesina like wll do all the search |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 733
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:23 pm: |
|
Gochi:
doesnt help bro//Like, kills where ever you use |
Nalla_baalu
Yavvanam Kaatesina Bewarse
Username: Nalla_baalu
Post Number: 8793
Registered: 06-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:20 pm: |
|
Ravanabrahma:
annai movers dhi oka manchi suggestion ivvandi ...austin to minneapolis moving friends telisina vaalu
Aug 11th weight -- 84 kg \bemmi.muniga icon
|
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 22110
Registered: 06-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:19 pm: |
|
Lenevo:
http://www.dba-oracle.com/oracle_tips_like_sql_index.htm
 |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 78651
Registered: 07-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:17 pm: |
|
pedda query lo where clause lo pass chesthunnaaru kadhaa like '%..' ani...
alaa kaakundaa what if you pass the filter in the From clause...does it improve performance
Original Query:
select * from a,b,c,d
where a.name like 'Sachin%'
New Query:
select * from
(select a.* from a where name like 'Sachin%') a
b,c,d |
Jaffaa
Mudiripoyina Bewarse
Username: Jaffaa
Post Number: 21721
Registered: 03-2008
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:09 pm: |
|
Lenevo:edo oakti seppi savu.. ida sava nookuthundi idii
sever ni oka paali vonchi mallaa restart cheyyi.... |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 732
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:05 pm: |
|
Jaffaa:
edo oakti seppi savu.. ida sava nookuthundi idii |
Jaffaa
Mudiripoyina Bewarse
Username: Jaffaa
Post Number: 21720
Registered: 03-2008
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 2:02 pm: |
|
table drop chesi empty table create cheyyi...fast ga vosthayi results |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 731
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 1:58 pm: |
|
Symbol_of_king:
Thanks bro.. i think this wil effect other queries..any way let me try that |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 730
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 1:58 pm: |
|
this is in sql server basically |
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 2112
Registered: 12-2005
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 1:57 pm: |
|
naku book knowledge tapithe realtime implementation experience ledu index partioning meeda...so just sharing info..see below links
http://stackoverflow.com/questions/1358490/is-a-globally-partitioned-index-bette r-faster-than-a-non-partitioned-index
http://stanford.edu/dept/itss/docs/oracle/10g/server.101/b10743/partconc.htm |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 729
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 1:45 pm: |
|
Symbol_of_king:
Index partitoning ??
migatha queries effect padda?? while using that index ?? |
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 2111
Registered: 12-2005
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 1:44 pm: |
|
"like" ni replace cheyyalemu anukunta...may be "range index partitioning" will help..i am not sure |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 728
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 1:43 pm: |
|
Konchem urgent idi.. emi anukokunda sodi anukokundaa .. emanna telisthee plzz kindly help brothers |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 727
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 1:34 pm: |
|
I am thinking to add another column to serach first_name easily..but what taht column should be ?? how tp figure out .. anedi ardam kataledhu ...
what if i add a bitmap columna and then serach with bit operator ??? will that help
any one have an idea with bitmap ?? |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 726
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 1:33 pm: |
|
Symbol_of_king:
Index doesnt help//Like is searching for entire indexes and table.. |
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 2110
Registered: 12-2005
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 1:28 pm: |
|
http://laurentschneider.com/wordpress/2009/07/how-to-tune-where-name-likebc.html
google search lo edi vachindi...may be it will help you |
Nalla_baalu
Yavvanam Kaatesina Bewarse
Username: Nalla_baalu
Post Number: 8792
Registered: 06-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 1:17 pm: |
|
bump
Aug 11th weight -- 84 kg \bemmi.muniga icon
|
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 725
Registered: 05-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, September 11, 2012 - 12:43 pm: |
|
I have table named person ..
columns
First_name,
last_name ,
address,
etc ;
ippudu problem antantee.
First_name like + '%' vadathanaru query loo..
and its searching for all the table..
Tables has 2 million rows and this is OLTP not olap..
Query taking 5 mins to execute it has other joins as well.. first_name = ani isthe < 1 sec lo vasthundii ..like rasam kabati taking time..
I checked indexes, statistics etc all Dba tasks from my end ..
fast ga ela rayaloo kodiga sepundrii |
Archives - 2012