Request-URI Too Long

[jalchr]

Well, I'm trying to optimize the querying of multiple documents based on multiple conditions, and to avoid hitting the 30 queries/session limit.

So, I have about 25K clients, I'm trying to query them in a batch of 1024 documents. The criteria is based on the client's name. 

I got this:

{"The remote server returned an error: (414) Request-URI Too Long."}

   at Raven.Client.Connection.HttpJsonRequest.ReadStringInternal(Func`1 getResponse)

   at Raven.Client.Connection.HttpJsonRequest.ReadResponseString()

   at Raven.Client.Connection.ServerClient.DirectQuery(String index, IndexQuery query, String operationUrl, String[] includes)

   at Raven.Client.Connection.ServerClient.<>c__DisplayClass24.<Query>b__23(String u)

   at Raven.Client.Connection.ServerClient.TryOperation[T](Func`2 operation, String operationUrl, Boolean avoidThrowing, T& result)

   at Raven.Client.Connection.ServerClient.ExecuteWithReplication[T](String method, Func`2 operation)

   at Raven.Client.Connection.ServerClient.Query(String index, IndexQuery query, String[] includes)

   at Raven.Client.Document.AbstractDocumentQuery`2.GetQueryResult()

   at Raven.Client.Document.AbstractDocumentQuery`2.get_QueryResult()

   at Raven.Client.Linq.RavenQueryProviderProcessor`1.ExecuteQuery[TProjection]()

This is typically the limitation of the url size in http get . 

My question, Is there a way to query using "Post" http verbs ?

[Ayende Rahien]

Jalchr,

Um... wow!

We don't support POST a query, and there are several things wrong with it;

* It can't be cached.

* Query with that many clauses is probably going to be slow.

Can you show a sample of your query, and explain what you are trying to do?

[jalchr]

Okay, this is one hell of a query , but that should be better than querying 1024 times :)

I believe adding an option to query with a "Post" verb would help

var clients = session.Query<Client, Client_Index>()

                      .Customize(x => x.UseHttpPost)

                      .Where(x => x.Name.In(namesList)

                      .ToArray();

This is the query ... take a deep breath:

==============================

Executing query '(Name:"HANSPETER GLOOR" OR Name:"KOLLIE NA AYAN" OR Name:"LAWRENCE ASOGBA" OR Name:"ANYA ARUODO IWO" OR Name:"JAMES KALU" OR Name:"KATE KALU UDEAGHA" OR Name:"NANCY EMMANUEL CHINWE" OR Name:"EMEKA SOMTO" OR Name:"VIOLET OSAYANDE" OR Name:"DUKE OBIEZE" OR Name:"OHAEMESI NDJIDEKA" OR Name:"PETER MISCHLER" OR Name:"MARGRAET ECHEFU" OR Name:"KINGSLEY KANU NWANKWO" OR Name:"MISSIS DORIS ENYIOMA" OR Name:"JULIANA CHEKWUBE OKEKE" OR Name:"KATE OKOEDION" OR Name:"DORIS OKOEDION" OR Name:"ALI SHAIBI" OR Name:"ANN D BEST NWAKOR" OR Name:"THERESE MONICK" OR Name:"PROPHET JAMES O  MKPAYE" OR Name:"CHRISTIAN EMEKA OKEKE" OR Name:"CHINONYE NWOSU" OR Name:"ISHOLA AKEEM" OR Name:"ISHOLA NURUDEEN" OR Name:"BOBBY WOOD" OR Name:"AGBO  KOSOLUCHUKWU ADAKU" OR Name:"GIFF SMITH" OR Name:"FRIDAY OMONIYI AKOLO" OR Name:"JUSTINA IMOH" OR Name:"GOSPEL UMA" OR Name:"DAVIDSON OSIRI NKECHI" OR Name:"ERNEST OGUAMALAM" OR Name:"JEANNINE SCHMIDT EDZOA" OR Name:"ANGOS EZE" OR Name:"NENEY GREY" OR Name:"ISATA CONTEH" OR Name:"MARCK DAVID" OR Name:"BERTHA EZIKA" OR Name:"CELESTINE OBIORA" OR Name:"ONUORAH JUDE UZODIMMA" OR Name:"WERNER HAAS" OR Name:"CHINYEREF OBINANI" OR Name:"ALEX MINGER" OR Name:"NAWBUEZE GODSWILL" OR Name:"NINA JENNIFER EME" OR Name:"DORCAS ONWAWOMA" OR Name:"NIXON NDAYE" OR Name:"AUGUSTINE NDUKWUEGBULAM NWATURUOBI" OR Name:"LUCY NEME UDEASGHA UMAZI" OR Name:"LIBERTY UWOTA" OR Name:"ONOPHIE BLESSING" OR Name:"PASCAL MINGER" OR Name:"JECOB NCOMO MORGAN" OR Name:"JUDE IKENNA UGWUEGBO" OR Name:"JULPIS AGBUGUI UKAWONG" OR Name:"UNITYODOIN OKHIREBHU" OR Name:"IBE EMMANUEL CHIEDOZIE" OR Name:"NNAKWE CHUKWUDI" OR Name:"BEATRICE OSAGIE" OR Name:"ROSELINE OSAGIE" OR Name:"NICK NGWA" OR Name:"MBIMBA NDOMBASI" OR Name:"DANIEL OGBIKUN" OR Name:"JOHN ONUOHA" OR Name:"OKECHUKWU ONOUHA" OR Name:"JUSTINA UGBOKE" OR Name:"CHIOMA TINA AGBODIKE" OR Name:"PASCAL MINGER" OR Name:"ALEX MINGER" OR Name:"EFE OMOROGBE" OR Name:"OB                AZYBE SUSAU" OR Name:"RACHEL NFUNDOAK" OR Name:"LIVINUS OGEH" OR Name:"JULPIS AGBUGUI UKOWONG" OR Name:"ANDREWS  OSALUMHENSE OKHIREBHU" OR Name:"CHRISTOPHER IZUEGBU" OR Name:"JENNIFER UGUCHI IZUEGBU" OR Name:"CARINE POWER TAGONO" OR Name:"CHINWENDU PEACE OGBONNA" OR Name:"DAVID MACK" OR Name:"BETHER EZIKA" OR Name:"GEORGETTE PRIEMI VAGLIETTE" OR Name:"ABGO KOSOLUCHUKWU ADAKU" OR Name:"JEFFERSON ASUENI" OR Name:"NWACHUKWU ABIGIRL" OR Name:"CHRIS OROU" OR Name:"CHUKWUDI NNAKWE" OR Name:"ROSALIE OSAGIE" OR Name:"PIERRE JEAN PIERRE" OR Name:"AGNES ONUOHA" OR Name:"EHIMEGBE ANTHONY" OR Name:"MAGARETH EHIMEGBE" OR Name:"ROGER FIRMIN MUSY" OR Name:"CHIKELUBA UJU" OR Name:"CHRISTOPHER AMADI" OR Name:"NOSA OSIFO" OR Name:"FELICIA OSIFO" OR Name:"GRACE AGOLIA" OR Name:"MICHEL NDUBISI OTILA" OR Name:"CHRISTOPHER OBI OKONKWO" OR Name:"EMMEKA SOMTO DAN" OR Name:"MIS HAPPINESS OJOY" OR Name:"CHAMSSIA SAID ALI" OR Name:"CHINONSO OGUNDU" OR Name:"JULIETTE CANDIOTTI" OR Name:"CHIMEZIE CLETUS EKPE" OR Name:"NKEMBE RUFIN" OR Name:"NWABUEZE G OGUGUA" OR Name:"NWOKIKE CHUKS" OR Name:"NOBERT SCHNEIDER" OR Name:"EZEOBI CHUKWUNONSO" OR Name:"EMMANUEL CHISOM" OR Name:"UJUMWA CHIOKE" OR Name:"OBIORA CELESTINE" OR Name:"JUDE UZODIMMA" OR Name:"DORIS ENYIOMA" OR Name:"RICHARD BENJANI" OR Name:"MICHEAL IKECHUKWU UCHEGBU" OR Name:"ABRAHAM ERHABOR" OR Name:"OSATRIN ERHABOR" OR Name:"ABDOULAYE SOW" OR Name:"AHAMEFULE ETHELBARI   CHIJIOKE" OR Name:"ONYEIKEDI NATHAN" OR Name:"UMEJIEGO ANTHONIA" OR Name:"JOSEPH AGU" OR Name:"EMMANUEL ANYIM" OR Name:"NNAZIM AZUBUIKE" OR Name:"CHUKWUKA KINGSLEY OLISEMEKA" OR Name:"JOHN NDUBUEZE" OR Name:"CHINASA BLESSING OBI" OR Name:"FAVOUR CALISTUS" OR Name:"AKWARI ODIKE" OR Name:"VICTORINE ROLANDE BIKIE ENDOUGOULOSI" OR Name:"CHUKWUEMEKA RAPHAEL" OR Name:"VICTORIA DANNECKER" OR Name:"CHRISTINA VANESS" OR Name:"AKINTUNDE AYODEJ DARE" OR Name:"CHIBUEKE EKPE SAMUEL" OR Name:"MATHEW OBIEZE" OR Name:"IFEANYI UGWUANYI" OR Name:"EMMANUEL OLUOMA" OR Name:"MONTEIRO LEONILDO" OR Name:"IFEANYI FRANCIS OKOYE" OR Name:"NDUBUEZE JOHN OBI" OR Name:"FRANCKLIN IFEANYI" OR Name:"NATHALIE MEKONGO" OR Name:"EBERE EZEILO" OR Name:"JOHN JACOB" OR Name:"DURU LINDA IFEYINWA" OR Name:"KHALIL FAWAZ" OR Name:"VICTOR             JEREM AH UWAKWE" OR Name:"FESTUS NWANOCHIE" OR Name:"OSITA EZE" OR Name:"JACOB STANLY" OR Name:"FRED RICK SUNDAY" OR Name:"IKEM OKECHUKWU EBELE" OR Name:"LOVINA CHINEYE OKORO" OR Name:"SHEDRACK EZEH" OR Name:"OGBA IKERE IBE" OR Name:"AJIKE GABRIEL UCHE" OR Name:"SIMON MOSER" OR Name:"VIVIAN DURU" OR Name:"DAN EMEKA SOMTA" OR Name:"APEH HILLARY" OR Name:"PEDRO IMFEL VITA JOAO" OR Name:"ANNIE MAFUTA" OR Name:"CHINEDU JUDE OKAFOR" OR Name:"JEAN PIERRE" OR Name:"ONUOHA AGNES" OR Name:"DAN EMEKA SOM TO" OR Name:"EVANGELINE SYLVIA CHIKODILI IGWEGBE" OR Name:"DARE AKINTUNDE AYODEJI" OR Name:"PRINCE CHIBUZO IGKEGB E" OR Name:"AGNES EYOMANA" OR Name:"HARRISON OJU" OR Name:"THERESE BISSABINGA" OR Name:"ONYEBUCHI ENWELUZOR" OR Name:"JOY DAVID" OR Name:"EDANI NABOTH AFAMEFUNA" OR Name:"MONDAY OLIGIE" OR Name:"CATHEREINE FOUDA" OR Name:"HELEN OKEKE" OR Name:"STEPHEN IZUEGBU" OR Name:"IKENNA OZOR" OR Name:"JOSEPH AIFUWA" OR Name:"FLORENCE YANOU" OR Name:"CELESTINA AGBODIKE" OR Name:"OLIGIE MONDAY" OR Name:"HANS KURZ" OR Name:"AGBODIKE CELESTINA" OR Name:"AGBOLIKE CELESTINA" OR Name:"ZINGA DIAKIESSE" OR Name:"SALY KONE" OR Name:"PATRICK UIT" OR Name:"IKENNA UZOR" OR Name:"PATTI LUVUETO NZOLAMESO" OR Name:"CHIEGE  MARY ROSE NGOZI" OR Name:"OYEDIYA ELEKWACHI" OR Name:"OKECHUKWU IHEANACHO OGUGUA" OR Name:"DAVID DALE LAWRENCE" OR Name:"EMEKA EMEKA" OR Name:"OKIGBO GIDEON" OR Name:"OKIGBO GLORY" OR Name:"ERIKA QUIMBERT" OR Name:"HARRISON OGU" OR Name:"EMMANUEL JUNIOR OKAFOR" OR Name:"UJU CHIKELUBA" OR Name:"ONYECHE KELECHI" OR Name:"REGINE SOLEIL NGO NTAMAG" OR Name:"JOY OBIAGELI NWANKWO" OR Name:"ANTHONIA UKPEBOR" OR Name:"AIGBIREMHON ADOLPHUS" OR Name:"VIVIAN EZE" OR Name:"THIERNO DIALLO" OR Name:"CHRISTOPHER OBI" OR Name:"EDEANI NABOTH AFAMEFUNA" OR Name:"EMMANUEL NGALA" OR Name:"FRANK CHUKUKA" OR Name:"EKEH CLEMENT" OR Name:"ANYANWU CALISTUS CHIBUEZE" OR Name:"FRANK IGBOERISIM" OR Name:"AUGUSTINE OGUEZE" OR Name:"PRINCE CHIBUZO IGWEGBE" OR Name:"MARIE ROSE OLIVEIRA SANTOS" OR Name:"SUNDAY IKECHUKWU" OR Name:"UGOEZE MKPADO" OR Name:"VANESSA MOUNKAMA" OR Name:"BLESSING AMADI" OR Name:"CECILE ABANDA" OR Name:"CRISTOPHER OBI" OR Name:"JOSETTE LEPLATTENIER" OR Name:"CHIGOZIE FRANK AGBODIKE" OR Name:"MONICK THERESE" OR Name:"ONYENUGWU OJU GODWIN UCHE" OR Name:"MARY OKWUEGBU" OR Name:"JEANNINE WICKART TCHYOMBO" OR Name:"CHIMASA BLESSING OBI AMADI" OR Name:"VICTOR IMAFIDON" OR Name:"JULIANA OKAFOR" OR Name:"PATRICIA OFFOR" OR Name:"VINCENT NNALUE OKONGWU" OR Name:"PATRICIA OFFOR" OR Name:"ABDOULAYE SOW" OR Name:"CYRIL IKECHUKWU OKONGWU" OR Name:"NICOLAS ABRIESTI" OR Name:"PAULINE NGONO" OR Name:"NNAMDI OKEKE" OR Name:"EGBOCHUO UMAZI AGBAI" OR Name:"AYOKUNLE DARE" OR Name:"LOVE CHINEYE OKORO" OR Name:"JULIANA AMADI" OR Name:"ONYEKA OKEKE" OR Name:"LORENZO EMILE LAGADEAU" OR Name:"MAMADOU KEITA" OR Name:"CHRISTIAN INNOCENT IKECHUKWU" OR Name:"THIERN0 DIALLO" OR Name:"HABI DIAWARA NTANKED KAMY" OR Name:"CELESTIN OKEKE" OR Name:"JUNIOR UFELLE" OR Name:"HENRY CHINEDU AGUDOSI" OR Name:"ALICE EMMA A AGUDOSI" OR Name:"CHUKWUJEKWU ERNEST UZODIMMA" OR Name:"TOCHWUKU NWAKOR" OR Name:"CELESTINE OKEKE" OR Name:"CHUKWUGEKWU UZODIMMA" OR Name:"CHUKWUGEKWU IWUAFOR" OR Name:"INNOCENT IKECHUKWU" OR Name:"QUEEN OBOH OLEABHIELE" OR Name:"GODWIN UCHE ONYENUGWU OJU" OR Name:"DANIEL CHUKWUNWEIKE OPARA" OR Name:"LUTE ZULU" OR Name:"JUSTINA S M BANASO" OR Name:"OPARA DANIEL CHUKWUNWEIKE" OR Name:"DIAS SANTOS" OR Name:"MACLEAN SOLUADE" OR Name:"EMEKA OHANUBE" OR Name:"CHINEDU NWANKOR" OR Name:"NKEM OKORO" OR Name:"PATRICK NZEZUE" OR Name:"MARCEL TOUYA" OR Name:"CHIJOKE NMAMOKO" OR Name:"CAROLE KELLER" OR Name:"MOSES AGU MBA" OR Name:"ISAAC S EGU" OR Name:"NJOKU OLIHE ORU" OR Name:"STEVEN A AHAEGBU" OR Name:"STEVEN A OHAEGBU" OR Name:"NGWAHBO PRUDENCIA" OR Name:"KAODILICHUKWU EKENTA" OR Name:"JOBENTUS  UGOCHUKWU DIM" OR Name:"NJOKU OLIBE ORO" OR Name:"BALA BAWA" OR Name:"UCHECHI OPARA" OR Name:"NKEMBI RIFFIN" OR Name:"NAWBUEZE GODSWIL OGUGUA" OR Name:"FREDERIC THOMAS" OR Name:"ACHIEBO CHINEDU" OR Name:"PATRICIA IFEDIORH" OR Name:"PATRICK IBENEME" OR Name:"ADEKOYA MARTIN" OR Name:"ADEKOYA JOSEPH OLUWOLE" OR Name:"EMMANUEL OYEBAMIDELE AKINOSHIN" OR Name:"OLUWASEUN JOSHUA OLAGUNJU" OR Name:"HENRY EHIS ALUKU" OR Name:"MARIAM OLASHUBOMI KENKU" OR Name:"EZE FRED" OR Name:"ADE JOHN FUNMI" OR Name:"CONSTANT UZAMERE" OR Name:"EGUAVOEN EHIGIATOR" OR Name:"ULAMEN ABIODUN" OR Name:"ITSEKI FRIDAY" OR Name:"OYEDEJI AYOTUNDE" OR Name:"OYEDEJI OLAOYE" OR Name:"DAVID EHIWAGIMEDE ALUKU" OR Name:"ALUKU EVELYN" OR Name:"AMAS GLORY" OR Name:"IMAGBE ENDURANCE" OR Name:"HENRI CHINEDU DURU" OR Name:"CHARITY ECHE" OR Name:"NOSAKHARE DAVID ENABULELE" OR Name:"FELIX EBOHON" OR Name:"OJO JOY" OR Name:"OJIEABULU FESTUS" OR Name:"EDEHA LU EDEHA LU" OR Name:"FELICIA ADAMS" OR Name:"AYANTOLA FADEKE" OR Name:"ADEPEGBA ADEDOYIN" OR Name:"ISAAC UGBO" OR Name:"CHRISTANA OSARETIN" OR Name:"SUNDAY EHIS" OR Name:"DANIEL OHIOKPAMWONYI" OR Name:"UGOCHUKWU EUCHARIA OKAFOR" OR Name:"CHINYERE OKAFOR" OR Name:"GOODEY OBI UMEH" OR Name:"IZUNNA UMEH" OR Name:"MARY OMOREGIE" OR Name:"JOSHUA OBINNA EGBO" OR Name:"KOLAWOLE BALOGUN" OR Name:"AKIN OLAYIWOLA" OR Name:"MERCY TAIWO" OR Name:"SAMSON TAIWO" OR Name:"OSAYIKI OKORO" OR Name:"NNAMANI NSUDE" OR Name:"IFEANYI JOSEPH NWAIGWE" OR Name:"BENEDICK OMORUYI OSUNDE" OR Name:"HENRY EDIAGBONYA" OR Name:"ANTHONY CHUKWUMA MBAEZE" OR Name:"RUTH CHICHI NGWUDILE" OR Name:"EDITH AYEMWENRE" OR Name:"ROSE IGBINIGIE" OR Name:"OSARO UYI" OR Name:"EVELYN ENOMA" OR Name:"GRACE NNACH CHIMA" OR Name:"GRACE OGBONNA" OR Name:"OGBEMUDIA MEREDITH" OR Name:"OSOBOR TIMOTHY" OR Name:"NNANNA JOHN" OR Name:"NJOKU LINDA OLUCHI" OR Name:"AILENOHIMORIA GLORIA" OR Name:"AIRENEKHUEMEN HENRY" OR Name:"EKWEBELEM OYINYECHI" OR Name:"NWORIE MARTIN NWAFURU" OR Name:"CHIJOKE ORUGBALA OBED" OR Name:"ADIMOHA JOY" OR Name:"USIFO JOHN" OR Name:"AGIODE CATHERINE" OR Name:"ELIMIHELE OMONO BEAUTY" OR Name:"OLATUNDE OLUSOLA" OR Name:"ISHOLA ANNU" OR Name:"OMOROGBE ROSEMARY" OR Name:"OMOROGBE JULIET" OR Name:"BALOGUN KOLAWOLE" OR Name:"BALOGUN KOLAWOLE" OR Name:"NWORIE ROSE CHINYERE" OR Name:"KENNETH CHIBUEZE AMADI" OR Name:"H CHIMEZIE AMADI" OR Name:"NIANG NDONGO" OR Name:"STELLA ELEMA" OR Name:"PAMELA ALANG" OR Name:"LISA IZOGIE" OR Name:"KATE EFOSA" OR Name:"TINA EKHAGUERE" OR Name:"LUCKY AVENBUAN" OR Name:"EMMANUEL AVENBUAN" OR Name:"MOSES ERIMIATOE" OR Name:"JUSTINA OMOROVBIYE NORUWA" OR Name:"SMART ROBISEN ASCINFO" OR Name:"EUNICE IJEMUAN" OR Name:"MERCY OSAYANDE" OR Name:"JOY OSAYANDE" OR Name:"NNAMDI ILECHUKWU ONYEDINMA" OR Name:"MRS JACINTA AMOGE ONYEDINMA" OR Name:"OKAEBEN RITA" OR Name:"EKHORUTOMWEN MARGARET" OR Name:"NWAJIOBI EKENE" OR Name:"IFEANYI CHUKWU NNAMDI" OR Name:"AYAVORO AUGUSTINE" OR Name:"EMILY AYAVORO BRIDGET" OR Name:"PATRICK DOZIE" OR Name:"AUGUSTINE OBIGBIBO" OR Name:"ENOMAMIUSE ABEL" OR Name:"ENOMAMIUSE OSARUMEN JOSEPH" OR Name:"OJIGBANI VALENTINE CHUKWUDIFU" OR Name:"OJIGBANI IFEYINWA" OR Name:"MONDAY JEMONH" OR Name:"KENNET EDOKPAIGBE" OR Name:"ANYADIOHA ALOY" OR Name:"ANYADIOHA IFEANYI F" OR Name:"CHUKS ASEWO" OR Name:"IKPIA MONDAY OBION" OR Name:"ROY IKECHUKWU IBEABUCHI" OR Name:"RACHAEL IBEH" OR Name:"PATIENCE OMOROGIEVA" OR Name:"OSAYEWENRE OMOROGIEVA" OR Name:"ADEOLA MARY" OR Name:"FOLORUNSO SEGUN" OR Name:"ALEMOH AMINAT" OR Name:"SUMAINAH MUSAH" OR Name:"WOHA AKEH" OR Name:"OLUMATI REX  A" OR Name:"EDOGUN RICHARD" OR Name:"UZAMERE ADESUWA" OR Name:"AUGUSTINE JOHN" OR Name:"EHIKIOYA BATHELOMEN" OR Name:"OJO BUKOLA" OR Name:"AYORINDE BOLA" OR Name:"ABDULAHI ZAINAB" OR Name:"ADEWOLE KENNY" OR Name:"OGUNTOLA BUNMI" OR Name:"ADEWOLE MICHAEL" OR Name:"ADEWOLE IBIRONKE" OR Name:"NEBECHI CHRISTIAN" OR Name:"NWOSU CHIKODI" OR Name:"OKORO AUGUSTINE" OR Name:"OKORO CHUKWUMA" OR Name:"SODUNKE ADEKUNLE" OR Name:"SODE FEMI B" OR Name:"AKINOLA FEMI" OR Name:"AKINOLA ALABA" OR Name:"ADETORO AKEEM ALIMI" OR Name:"JOLAOSHO JONATHAN OLADIMEJI" OR Name:"ANIUZU PENELOPE" OR Name:"ROY ANYAJI" OR Name:"CORK YOMI" OR Name:"OBISANYA YEMI" OR Name:"OKOLIE FRANCIS" OR Name:"OKOLIE GODWIN" OR Name:"UJUNWA CHIMEZIE" OR Name:"ONWUZOBE ONYEBUCHI" OR Name:"ASIRU ADELAJA" OR Name:"ASIRU IYABO" OR Name:"NIMBE VIOLET" OR Name:"OGEDEGBE       S OGEDEGBE       S" OR Name:"ONIGBODE KENNY" OR Name:"ONIGBODE OLAKUNMI" OR Name:"IGHOROJE CYNTHIA" OR Name:"CHUKWNAYE CHARLES NNANNA" OR Name:"SILVIA IZIGBUWA" OR Name:"O    ESTHER IMARUOMWANKE" OR Name:"OMONIGHO ERAH ISAMU" OR Name:"MERCY ISAMU" OR Name:"UFUOMA JAVE" OR Name:"ESTHER NKECHI UGWU" OR Name:"GODWIN TOMA" OR Name:"KATHERINE ANYANWU" OR Name:"MOSES BENJAMIN OSAGIEDE" OR Name:"LINCOLN IDOH" OR Name:"ADEBUSAYO OLUWADAMILOLA BOBADE" OR Name:"OJO EMMANUEL" OR Name:"CHARLES EDION EZEKWE" OR Name:"DAN EMELI" OR Name:"JOHN ENAGBALE" OR Name:"RACHAEL OSIBHASEVA ENAGBALE" OR Name:"TAIWO LOLA" OR Name:"TAIWO OLAWOYIN" OR Name:"ANIKWE CHUKWUDI" OR Name:"OHAGWU OSUNDU" OR Name:"OKEBUGWU MAY" OR Name:"OKEBUGWU JACOB" OR Name:"EBIKUELUYE BABINE" OR Name:"EBIKUELUYE BENEDICT" OR Name:"MONDAY ENEHIKHARE" OR Name:"PATRICIA EBOSELE" OR Name:"IFEANYI KINGSLEY NGAOJONJOKU" OR Name:"SANNI RUKAYAT" OR Name:"SANNI ISIAKA" OR Name:"BALOGUN OLAIDE RONKE" OR Name:"NWAOKOBIA JOAN" OR Name:"NWOKO LYNDA OWEN" OR Name:"EJIRO IGBI" OR Name:"IKIPONMWOSA IMADE" OR Name:"KINGSLEY ATUWAOGU ORJI" OR Name:"IFEANYI OHAI" OR Name:"AZORO FRANK" OR Name:"TOCHUKWU C NOSIKE" OR Name:"TOMINIYI BABATUNDE" OR Name:"AFOLALU CLEMENT" OR Name:"NJOKU ONYEKACHI ONYEKACHI" OR Name:"EKWE LINDA UCHECHI" OR Name:"ALLI ADEPEJU" OR Name:"OYEWOLE BOSEDE OPEOLUWA" OR Name:"OSAROBO MAGDALENE" OR Name:"ENADEGHE COMFORT" OR Name:"JOHNSON ADEWALE" OR Name:"ESHO BENSON" OR Name:"FATOLA KAYODE" OR Name:"FATOLA TUNDE" OR Name:"MOSES JIDAYI" OR Name:"LUBARYU DANJUMA" OR Name:"ITOHAN FRANCA ENOBAKHARE" OR Name:"ONAJITE OTITE" OR Name:"JUSTINE AIGBE" OR Name:"MONDAY UHUNAMURE OGBEMUDIA" OR Name:"EVANS PROSPER OKOJIE" OR Name:"UWADIA DESTINY AGIE" OR Name:"UBA JUDITH" OR Name:"AREGHAN RITA" OR Name:"OMOLE VICTOR" OR Name:"SAMUEL OLUFISAYO OLOWU" OR Name:"OKAFOR UGO" OR Name:"OKAFOR CHUKWUDI" OR Name:"DANIEL EDITH" OR Name:"DANIEL OLUWAFEMI" OR Name:"NATHANIEL OSARODION OSAS" OR Name:"ANITA E AGBONZEGBE" OR Name:"ADENIRAN PATRICK FAJEMIROYE" OR Name:"RHODA OLUSOLA OJETUNDE" OR Name:"ROSALINE MGBORIE CHUKWU" OR Name:"CHARLES  CHIDI WODO" OR Name:"SAMUEL NMAJU" OR Name:"OLUBUKOLA TAOFIK ANIFOWOSE" OR Name:"SHOLA LOLADE ANIFOWOSE" OR Name:"LUCKY IYAWE" OR Name:"ROTIMI EKE" OR Name:"OSARENOMA ILEKHUOBA" OR Name:"JOHN EGUAGIE EMWINYUWA" OR Name:"TERESA OSA OMORUYI" OR Name:"COMFORT OSAGHEA" OR Name:"JOSEPHINE ROSSY ODIA" OR Name:"OCHUKO EGHWOFOBE" OR Name:"ESTHER NNENNA CHIMA" OR Name:"EPHRIAM CHIKERE OKORO" OR Name:"ESTHER PAUL MAMZA" OR Name:"TOCHUKWU MURPHY OFODILE" OR Name:"UMUMMA MARTINS OFODILE" OR Name:"CLARA KENNY OBIRE" OR Name:"ENEHI SUNDAY" OR Name:"IGBINEDION OSAGIE" OR Name:"OSAGIE CARO" OR Name:"ELIMIHELE SHOLA" OR Name:"ELIS VICTOR" OR Name:"OGIEHOR SANDRA" OR Name:"OGIEHOR FELIX" OR Name:"ADEGOKE OLUBUNMI" OR Name:"ADEGOKE AYOTUNDE" OR Name:"FOLORUNSHO JENNIFER" OR Name:"IHEANACHO CELINA" OR Name:"OKECHUKWU COSMAS" OR Name:"ONWACHEI FELIX" OR Name:"ONWACHEI THERESA" OR Name:"AKAEHOMEN JULIUS" OR Name:"AKAEHOMEN AUSTEEN" OR Name:"OKORO JUDE" OR Name:"OKORO IHEOMA" OR Name:"OKAFOR AMILO" OR Name:"OKUEFUNA CHIKE" OR Name:"UZAMA KINGSLEY" OR Name:"UZAMA KENNETH" OR Name:"ADENOMO DORA" OR Name:"ADENOMO VICTOR" OR Name:"FAMILONI ENIOLA" OR Name:"AJITARMU YEMISI" OR Name:"ADENIJI KEHINDE" OR Name:"ADENIJI IYABO" OR Name:"ANIAGOLU FEBIAN" OR Name:"ANIAGOLU NWAKAEGO  GLORIA NWAEZE" OR Name:"SHERIKI BOLA" OR Name:"OGUNDANA TEMITOPE RAFLAT" OR Name:"EDIONWE ISAAC" OR Name:"OYEMIWAN JOHN" OR Name:"OKOH JOHN" OR Name:"ILUOBE DEBORAH" OR Name:"AGHAYARE JOY" OR Name:"AGHAYARE JANET" OR Name:"IFETAYO OKE" OR Name:"ADEWUNMI OLUYEMISI" OR Name:"OJO TOLULOPE" OR Name:"BOJE ARTHUR" OR Name:"UGBEYE GEORGE" OR Name:"GBENGA SHOTADE" OR Name:"KEMI SHOTADE" OR Name:"UYI NOSA" OR Name:"PROSPER ODIGIE" OR Name:"AKO GEORGINA" OR Name:"OKONKWOR RITA" OR Name:"EUGENE CHINAGWA" OR Name:"FAVOUR OLILEANYA ANYANWU" OR Name:"CHUKWUDI IBEABUCHI" OR Name:"ROSEMARY OSAZEE" OR Name:"OSEMWENGIE IGIEBOR" OR Name:"FELICIA I EHIGIE" OR Name:"OSARIEMEN AISAGBONBUOMWAN" OR Name:"DICKSON ENOGIERU" OR Name:"JOLLY ENOGIERU" OR Name:"IRENE NONYELUM OZOAGU" OR Name:"PHILOMINA AGBO" OR Name:"ANYADIOHA IZUCHUKWU MISHEARK" OR Name:"CHIJIOKE AGAZIE" OR Name:"CHARLES IBHAROGA" OR Name:"DAVID ODEGUA" OR Name:"IFEANYI  FELIX OKONKWO" OR Name:"STEPHEN OKONKWO" OR Name:"KEN OSAMEDE OMORUYI" OR Name:"KELVINSON EDAYI" OR Name:"COLLINS CHUKWUYEM IYORIKE" OR Name:"HILARY OMOROJIE" OR Name:"JENNIFER EGHAREUGA OSAGIE" OR Name:"JERRY OIBOH" OR Name:"FRED OGBEBOR" OR Name:"RITA OGBEBOR" OR Name:"ELIZABETH AMAYO" OR Name:"ESOSA AUGUSTINE EHIGIATOR" OR Name:"KINGSLEY AKPOS" OR Name:"RUWA  LARABA ABDULLAI" OR Name:"ONIFADE TITUS" OR Name:"OLORODE LANREWAJU MORAKINYO" OR Name:"FAVOUR OVEDE" OR Name:"MARGERET ERURU" OR Name:"BOBY EGHOSA MICHEAL" OR Name:"NWACHUKWU CHRIS" OR Name:"NWACHUKWU REGINA" OR Name:"ACHUGBU AZUKA" OR Name:"CHIEDO SOLOMON" OR Name:"VICTORIA NWAGIRIGA" OR Name:"ODIGIE PAUL" OR Name:"OSEMWEGIE QUEEN ESE" OR Name:"OSEMWEGIE MERCY" OR Name:"AGHEDO JULIET" OR Name:"TINA ULAKPA" OR Name:"MAFIDON FELICIA" OR Name:"AJAYI ROSE" OR Name:"BASILIA IFEOMA UZOKWE" OR Name:"CHARLES TOCHUKWU OZUOME" OR Name:"OBI TINA" OR Name:"MBADUGHA IKE GODSON" OR Name:"AFOLABI OLAJIDE" OR Name:"ODUSINA SAMUEL" OR Name:"OGIEMWONYI GODSPOWER" OR Name:"OGIEMWONYI EDEMA" OR Name:"JOY ADAM" OR Name:"EVBUOMWAN EROEWEAN" OR Name:"UBBOR UCHENNA" OR Name:"UBBOR FELICIA" OR Name:"KABURUK PAULINE" OR Name:"CHIDAWA YANANG" OR Name:"ALEH OGADINMA" OR Name:"PAUL EGGD" OR Name:"OBARO OMOWUMI" OR Name:"OGBEIFUN ESTHER" OR Name:"NWANERI FIDELIS CHIJIOKE" OR Name:"NWANERI REGINA" OR Name:"OFFOR IK OFFOR IK" OR Name:"CHIBUEZE JUDE" OR Name:"ABODUNRIN VIVIAN" OR Name:"OZAKPOLOR NOSA" OR Name:"AJECHE CLEMENT" OR Name:"AJECHE GODWIN OGAR" OR Name:"HARUNA BUKOLA" OR Name:"HARUNA MODINAT" OR Name:"AKINBOLA ALFRED" OR Name:"OLANREWAJU ADEBIMPE BLESSING" OR Name:"AGU RAYFORD OBIBUEZE" OR Name:"CALISTA NNEKA OBIBUEZE" OR Name:"IMAFU MONDAY" OR Name:"EHANA RAYMOND" OR Name:"ENODOE RICHARD" OR Name:"NNONA EMEKA" OR Name:"NNONA MICHEAL" OR Name:"EGHOSA FRANCIS AGHAKU" OR Name:"ROBERT CHIDI" OR Name:"NZEWI OGONNA" OR Name:"SAMUEL OVBIAGELA PHILO" OR Name:"OVBIAGELE AGNES" OR Name:"OSAROGIAGBON RITA" OR Name:"EDIOWE AUSTIN" OR Name:"AKINTUNDE OWOLABI" OR Name:"AKINTOLA SAMSON" OR Name:"OGOR JUDE" OR Name:"OGOR HENRY ONYEMAZU" OR Name:"CHARITY CHARITY" OR Name:"AMADASUN ELIZABELTH" OR Name:"KAYODE ABIMBOLA" OR Name:"ADELANI OLUWATOYIN" OR Name:"ADA FAITH" OR Name:"OBASEKI GLORY" OR Name:"ETSEYATSE VIVIAN" OR Name:"KANWEI PATRICK" OR Name:"OLASUPO FOLAKE" OR Name:"IYIOLA OLAOLUWA" OR Name:"OYENEYE ABOLORE" OR Name:"KAZEEM AMINAT" OR Name:"EDOGUN RITA" OR Name:"ODIASE LINDA" OR Name:"LAWRENCE BOLA" OR Name:"AKAMBI SWUBATU" OR Name:"ISRAEL ANTHONY" OR Name:"CHIDI SUCCESS" OR Name:"IZUKWE HENRY" OR Name:"OBULOR JOY" OR Name:"OBANOR LUCKY" OR Name:"PIUS ODION" OR Name:"ERO GEORGE" OR Name:"OKEREGHA EMUOBO" OR Name:"OKEREGHA GRACE" OR Name:"EHIRIM CHILE" OR Name:"ANYIMIGBO FRANCIS" OR Name:"VITUS NNAMDI" OR Name:"ONYEBUCHI VINCENT OKONKWO" OR Name:"AKINTEMI OLUDOTUN" OR Name:"AKINTEMI SILEOLA" OR Name:"DIKE RUFUS UKA" OR Name:"ANYANSO MAUREEN U" OR Name:"ADIMOHA CHIZOBA" OR Name:"OFONZE OKEREKE C" OR Name:"ONYEKWERE FAUSTINA" OR Name:"ADENIYI FLORENCE NIKE" OR Name:"CEMENT DIMKPA" OR Name:"TIMOTY TUNDE AINA" OR Name:"JAYESIMI OLAWUNMI" OR Name:"OLUWAFEMI BENJAMIN" OR Name:"SODIMU TORO" OR Name:"OLUDIMU JOKE" OR Name:"ABO MADIYANA MBACKE" OR Name:"AJOSE ADEMOLA ADEGBORIOYE" OR Name:"OYEYEMI OLATUBOSUN IKUESAN" OR Name:"NZEADU GINIKA" OR Name:"NZEADU VIVIAN  C" OR Name:"OMOWEMWENGUA VICTOR" OR Name:"OMOREGIE SUNNY" OR Name:"OKOLIE VERA" OR Name:"EMEH AFAM" OR Name:"ODU CHRISTIAN" OR Name:"MACAULAY CHUKWUNYERE UGORJI" OR Name:"SABINUS UGORJI" OR Name:"NAOMI OMOLEGHO" OR Name:"OMOLEGHO SOA" OR Name:"BOSEDE LOTO" OR Name:"ANDY CHARLES" OR Name:"CHRISTIANA DAVID EDEM" OR Name:"IJEOMA FLORENCE IROEGBU" OR Name:"OYINLOLA MUSILI" OR Name:"BABALOLA KAYODE" OR Name:"THEOPHILUS MUSA" OR Name:"EHIRIM KENNETH" OR Name:"EHIRIM FIDELIS" OR Name:"MGBADA SIMON" OR Name:"MGBADA CONFIDENCE" OR Name:"ERHUNMWUNSEE JOSEPH" OR Name:"AMECHI PRINCE" OR Name:"OJO IFUEKO" OR Name:"LADEGA ABIODUN" OR Name:"TOGLAS MARTINS" OR Name:"JOHNSON PAUL" OR Name:"UZODIMA ANAYO" OR Name:"AGUBIKE CHRISTIE" OR Name:"AGUBIKE CLEMENT" OR Name:"NICHODEMUS OZOAGU" OR Name:"POUL ANUKWU" OR Name:"CHARLES ANUKWU" OR Name:"OSASUMWEN IMADONMWINYI" OR Name:"FLORENCE OMOSEFE" OR Name:"VERO OGBEIDE" OR Name:"ABU EKOMOBA" OR Name:"KENNEDY OMOREGIE" OR Name:"MICHAEL OGBEIDE" OR Name:"MERCY OKEKE" OR Name:"THANKGODLAWRENCE NWANNA" OR Name:"OTEH YVONNE" OR Name:"OHUIMUMWEN DORA" OR Name:"FOLORUNSO ROTIMI" OR Name:"BADIRU ADEMOLA" OR Name:"SEGUN ADEWUMI" OR Name:"SAMUEL FUNMI ADAMS" OR Name:"GBAYE EMMANUEL" OR Name:"GBAIYE OMOMAYOWA" OR Name:"EKHORUTOMWEN ITOHAN SANDRA" OR Name:"EKHORUTMWEN ANTHONIA" OR Name:"KEHINDE KOLAWOLE" OR Name:"KEHINDE OPEYEMI COMFORT" OR Name:"FATUS REMI" OR Name:"WILLIAMS RILWAN OLATUNJI" OR Name:"MONEKE GODWIN" OR Name:"MONEKE PHILIP CHUKWUDOZIE" OR Name:"OLOKO ADEOLA" OR Name:"BALOGUN SAHEED" OR Name:"SALAJA ABIODUN" OR Name:"AZEEZ 0LAWALE ISAKA" OR Name:"ALAFAA ANYANATE KARIBOYE\-IGBO" OR Name:"OLOSIA DEREK KARIBOYE\-IGBO" OR Name:"AGBOOLA OLA" OR Name:"AGBOOLA OLUFEMI" OR Name:"AJISAFE FOLASADE" OR Name:"ADELAKUN OLAWALE" OR Name:"ERIC DARKO" OR Name:"OGHOGHO AGHATOTIKOLO" OR Name:"NAJIMU MOHAMMED AHMADU" OR Name:"SALAMI AKEEM" OR Name:"SHOBAYO AZEEZ" OR Name:"ECHIPUE JOY" OR Name:"ERUGO ODOEMENAM MIKE E  N" OR Name:"GOODMAN PETER" OR Name:"UMEH ONYINECHI DIVINE" OR Name:"KEHINDE OLUDELE" OR Name:"BELLO FELLICIA OLUWAKEMI" OR Name:"IYAMU BLESSING" OR Name:"UWOGHIREN DAVID" OR Name:"AKINTOYE MOJISOLA" OR Name:"OREKOYA BABATUNDE" OR Name:"OKI REMI" OR Name:"OKI RAB" OR Name:"AREMU FUNMI" OR Name:"AKINSETE YINKA" OR Name:"SHITTA OLAWALE" OR Name:"OSIKOYA MUFUTAU" OR Name:"OGUNS BIMBOLA" OR Name:"N ELO N ELO" OR Name:"ONIBOKUN CHARITY" OR Name:"UCHE STEVE" OR Name:"OKOYE CHINEDU FRIDAY" OR Name:"ADENUGA ABOSEDE" OR Name:"UGWUMBA OBINNA" OR Name:"UGWUMBA KELECHI" OR Name:"FESTUS ODE OSAGIE" OR Name:"GRACE IGIEBOR" OR Name:"FRANCIS IYASE" OR Name:"TONY IYOBO ORUMWENSA" OR Name:"JONATHAN EDWIN CHIBUZO" OR Name:"KATE JONATHAN" OR Name:"ANENE EZE" OR Name:"JAMES LEONARD ANAYOCHUKWU" OR Name:"IBEKWE JOHN" OR Name:"IBEKWE NGOZI" OR Name:"OMOLE KEHINDE" OR Name:"OVIE O CAESAR" OR Name:"AKPOYOMARE GODWIN" OR Name:"INYERE PETER" OR Name:"INYERE IFEOMA IKECHUKWU" OR Name:"OSAYANDE AMOS" OR Name:"OSAYANDE BRIGHT" OR Name:"AGUNBIADE JAYEOLA" OR Name:"ADEGOKE MARYANNE" OR Name:"ONWUZURUIKE CHARLES" OR Name:"OKPALAOKA JEKWU" OR Name:"ABHULIMEN HOPE" OR Name:"ABHULIMEN MARY" OR Name:"IBEAWUCHI OKECHUKWU" OR Name:"NWOGU CHIGOZIE CHIMEZIE" OR Name:"OBASI JOSEPHINE" OR Name:"OKAFOR CHRISTAIN" OR Name:"IGUMA FAITH" OR Name:"ORUCHE CHARLES" OR Name:"ANENE MARGARET" OR Name:"NOWKOCHA MONICA" OR Name:"IMAGBOVOMWAN EGHOSA" OR Name:"ENOMA LUCKY" OR Name:"OLUREMI TITILAYO" OR Name:"AFOLABI OPEYEMI" OR Name:"OKORONKWO SARA" OR Name:"NGELE EASY NGWOBIA" OR Name:"AJA EVENLY" OR Name:"IYAGBAYE NACY OSAMEDE" OR Name:"OKOGUN FAITH" OR Name:"OKOGUN ISAAC" OR Name:"NWOGA OBI CORNELIUS" OR Name:"ENOMAMISUE EDITH" OR Name:"OGBEIDE PARTRICK" OR Name:"LAWANI FLORANCE" OR Name:"LAWANI OSAHON" OR Name:"OGUNSAMI BOLANLE" OR Name:"OGUNSAMI SEGUN" OR Name:"ODUNTAN MICHAEL" OR Name:"ODUNTAN OLAMIDE" OR Name:"SHOBOYEJO TITILAYO" OR Name:"AJISAFE LEKAN" OR Name:"EDEH KENNETH" OR Name:"EDEH THERESA" OR Name:"EMEHELU QUEENDALINE" OR Name:"EMEHELU ALICE" OR Name:"IDEHEN JESICA" OR Name:"OMOKHEYEKE GLORIA ILEKE" OR Name:"KANNIKE BABAJIDE" OR Name:"SULAIMAN ABIOLA TITILOPE" OR Name:"IBE JOSEPH ONUORA" OR Name:"IBE CHINYERE" OR Name:"ASEMOTA MARTHA" OR Name:"USENBOR IKPONMWOSA" OR Name:"OMONKHADION PATIENCE" OR Name:"ESTHER OKIEMHEN" OR Name:"OSAZUWA AIBUEDEFE" OR Name:"IKECHUKWU GEORGE MADUBUIKE" OR Name:"MAGNUS E NGWU" OR Name:"JOSEPH DESTINY" OR Name:"KINGSLEY AKPOS" OR Name:"KINGSLEY IZUCHUKWU OKOYE" OR Name:"UCHE M OKOYE" OR Name:"EMMANUEL IKENNA OZUOME" OR Name:"EVANS JB OSAGIE" OR Name:"SUNDAY OSAGIE" OR Name:"EDITH EGBEIYE" OR Name:"EUNICE MAKU" OR Name:"COMFORT OSAGIE" OR Name:"BETTY DIRISU JOHN" OR Name:"JOSEPH OMOBUWA" OR Name:"DESMOND OMOS UWADIA" OR Name:"FESTUS EDOMWONYI" OR Name:"OKECHUKW TIKE" OR Name:"EMMANUEL CHIKAOTILI DIKE" OR Name:"EJIGBOYE BOLA" OR Name:"EJIGBOYE KOLAPO" OR Name:"ABIOYE FATAI ADETUNJI" OR Name:"OKEKE MIRIAM" OR Name:"OKEKE GRACE" OR Name:"ADESINA KUDIRAT" OR Name:"YESUFU OLADIRAN" OR Name:"NWOGU UCHENNA" OR Name:"NWOGU ISAAC" OR Name:"ONOSIAKE MICHAEL" OR Name:"ONYAVWARO EJIRO" OR Name:"UDUM SR PACE" OR Name:"UDUM SYLVIA" OR Name:"EVWODERE ESEOGHENE" OR Name:"ENAKPOYA FLORENCE" OR Name:"OKAFOR CHRIS" OR Name:"ONYONYOR STANLEY" OR Name:"SANNI TOPE" OR Name:"OLAORE NAHEEM" OR Name:"IHEANACHO STELLA" OR Name:"IRO CHINEDU" OR Name:"ERUKA JOHN" OR Name:"MONDAY OGHENERO TONWE" OR Name:"ALEX OMONIYI" OR Name:"AMBROS SYLVANUS" OR Name:"UYI AUGUSTINE" OR Name:"AIRHIHENBUWA JOSEPH" OR Name:"ADELEYE TUNDE" OR Name:"ZUBARU BASHIRU" OR Name:"VICTOR MICHAEL" OR Name:"AKENUWA JOY" OR Name:"UWAH EBERE" OR Name:"IROH ALEX" OR Name:"OMOSHOWON TEMITOPE" OR Name:"OMOSHOWON RAUFU" OR Name:"ABIODUN OLADAYO" OR Name:"EWUMI OMOLARA" OR Name:"OBI NGOZI" OR Name:"IWUORIE ADOLPHUS" OR Name:"ODUKOGBE LANRE" OR Name:"OSILAGUN MODUPE" OR Name:"EGHAREVBA VICTOR" OR Name:"OSAHON VERO" OR Name:"ADEYEMI ADEYINKA" OR Name:"OLUSHOTO ESTHER" OR Name:"ADIMABUA OKONKWO" OR Name:"UGOCHUKWU NDUKA" OR Name:"CHINONYELUM MATILDA OZOKOLIE" OR Name:"EVELYN EDEHIA" OR Name:"COLLINS EDEHIA" OR Name:"CLIFFORD ASEMOTA" OR Name:"MERCY ENOTIE" OR Name:"STANLEY ISERHIENRHIEN" OR Name:"CHARLES IMUIDA" OR Name:"OLADAPO STELLA" OR Name:"ADESIDA YINKA" OR Name:"AFOLABI MARY" OR Name:"SOGBESAN AMUDAT AYINKE" OR Name:"HELEN JUMOKE DOSUMNU" OR Name:"UDEME AKPABIO DANIEL" OR Name:"JAMES STELLA" OR Name:"OKOH CECILA" OR Name:"KEHINDE JANET OLAAYO" OR Name:"OYEDEKO GBENGA" OR Name:"OKUNLOLA ADEBOUMI" OR Name:"MORAKINYO JAMES" OR Name:"OBAHOR KELVIN" OR Name:"ROBERT BODE AKIN" OR Name:"ROBERTS AKINBODE JUWON" OR Name:"ONONUJU ANTHONY" OR Name:"ONONUJU JUSTINA OBIAGELI" OR Name:"OLAJIDE STEPHEN" OR Name:"THOMAS YEMI" OR Name:"ALE SUNDAY" OR Name:"SAMUEL AKOMOLAFE DARE" OR Name:"ADELEKE SHADE" OR Name:"OLORUNKEMI HAKEEM" OR Name:"BLESSING OTI" OR Name:"FUNMIOLA ALUKU" OR Name:"VERA ENEHIKHARE" OR Name:"KINGSLEY OMOBUDE" OR Name:"CLEMENT DIMKPA" OR Name:"OWHORNUOGU WEJINYA" OR Name:"RAMONI AKEEM" OR Name:"BOLANLE OMISADE" OR Name:"OKONKWO DONA" OR Name:"OKONKWO REGINALD" OR Name:"OMETAN EUGENE" OR Name:"IKEH MATTHEW N" OR Name:"IGWE WILLY" OR Name:"AGIM CHIOMA" OR Name:"OLUMOROTI BOSEDE BETTY" OR Name:"AGU FRANCA" OR Name:"EKOH NWASOKA" OR Name:"KELLY OSAGIE EMOVON" OR Name:"OSABUOHIEN EMOVON" OR Name:"SUNNY WILLIAM" OR Name:"EBELECHUKWU NWALI" OR Name:"AMINU SARATU" OR Name:"BELLO TUKUR" OR Name:"AKINRINADE ZAINAB" OR Name:"ODIASE OSARO" OR Name:"ODARO PAT" OR Name:"CHIGBU CHINYERE" OR Name:"ANYAUMUNNA JACHIKE")' on index 'Client/Entity' in 'http://localhost:8088'

Done !

[Ayende Rahien]

Okay...

What are you trying to _do_ here?

[jalchr]

Well, I'm trying to optimize the querying of multiple documents based on multiple conditions, and to avoid hitting the 30 queries/session limit. or I should query for each client and figure out away to overcome the limitation of the number of requests per session.

So, I have about 25K clients, I'm trying to query them in a batch of 1024 documents. The criteria is based on the client's name. 

P.S. I don't care for the HttpGet cache for this specific case 

[Ayende Rahien]

What are you going to do with so many customers?

In other words, I am more interested in the actual scenario that you are trying to solve than the problem with RavenDB.

[jalchr]

I would like to be able to upload an excel file with thousands of client's info and I would like to make sure no duplicates are there, So I would search by their names, before I decide which clients would be inserted and which get rejected.

This is one of the heavy queries, I mentioned before :)

[Ayende Rahien]

You are better off doing something else, then.

You can ask the index to give you the unique terms for an index, that gives you basically a list of distinct names, which you can then compare more easily in memory.

[jalchr]

You can ask the index to give you the unique terms for an index, 

Any sample code this (Select Distinct) ?

This particular case might be solved as you suggested, but I believe the "HttpPost" verb should be an option at hand for querying, at the query level and at the configuration level.

In the future, when OAuth is implemented in Raven, and the data server might be somewhere across the globe, I might use "HttpPost" for querying, because I don't want anything cached across the internet servers.

So, I vote for having that capability at hand.

 

 

[Ayende Rahien]

I would rather do something else, and provide support for Multi Get operation.

Thing about something like:

POST /multi_get

[

  { method: GET,  url: /docs/users/123 },

  { method: GET, url: /indexes/clients?query=... }

]

I don't think that we can support caching for this, but it would still be pretty good option.

[jalchr]

On Tuesday, June 28, 2011 2:14:25 PM UTC+3, Ayende Rahien wrote:

POST /multi_get

[

  { method: GET,  url: /docs/users/123 },

  { method: GET, url: /indexes/clients?query=... }

]

First, Isn't this a Post Request?

Second, I don't know where this "Multi-Get" is used ? to batch multiple queries into one ?

Third, if Multi-Get is not going to be cached, you can use the http-post with same "limitations".

Forth, with Multi-Get ... we still have the same Uri length limitation.

[Thomas Freudenberg]

The next step would be providing a concept of Futures in the client API. All future queries should be collected and a single /multi_get issued when the first result is about to be requested.

[Ayende Rahien]

Jalchr,

Multi Get is basically usinga  single POST request to batch multiple GET request.

It removes the URL query limit, too, because we use a post.

We will need a more sophisticated approach for the server caching, but we can cache that too, using the same idea.

The idea is that we expose this on the client as Future queries.

[jalchr]

Excellent ... I love it 

[jalchr]

Just to make sure I got you,  so when Futures is added, that huge query will work ?

var clients = session.Query<Client, Client_Index>()

                      .Where(x => x.Name.In(namesList)

                      .Futures();

This will produce a multi-get Post query ?

[Ayende Rahien]

Yes, that is the idea.

[jalchr]

Any chance for an estimated time for this to come along ?

[Ayende Rahien]

Hopefully this week, maybe next.

Any pull requests on this would be more than welcome.

[jalchr]

I would love to work on this, unfortunately my schedule is very tight.

[Ayende Rahien]

Started working on this. The wire format issue is actually pretty simple, and I also managed to get it to work with caching (http only, didn't touch aggressive) nicely.

Now the problems of the client API starts to pop up.

A) I think it would be pretty hard to make it work this way in the code - means big refactoring.

B) How do you set things up so it doesn't uglify the API ?

We didn't worry about it too much in NH, because there was much point, the API interface was already ugly, but I want to reduce as much as possible the # of API calls that people need to know.

[jalchr]

How about make the api look as is now (without forcing the explicit use of "Future()") 

and let the api choose to use what you call Multi-get when the url size (of regular-get) exceeds its limits ?

So instead of me writing this:

var clients = session.Query<Client, Client_Index>()

                      .Where(x => x.Name.In(namesList)

                      .Future();

I will use the plain old good:

var clients = session.Query<Client, Client_Index>()

                      .Where(x => x.Name.In(namesList)

                      .ToArray();

and the user doesn't have to worry about anything ... it should just work !

[Ayende Rahien]

Not a good idea, I think.

And doesn't solve the issue of how to handle the API for explicit futures.