# Huge XML DB search problem

**URL:** https://forum.kirupa.com/t/huge-xml-db-search-problem/57187
**Category:** flash
**Created:** [July 11, 2004, 4:56am UTC](https://forum.kirupa.com/t/huge-xml-db-search-problem/57187 "2004-07-11T04:56:55Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Deril](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/deril/32/63_2.png) [@Deril](https://forum.kirupa.com/u/Deril)
#### Post date: [July 11, 2004, 4:56am UTC](https://forum.kirupa.com/t/huge-xml-db-search-problem/57187/1 "2004-07-11T04:56:55Z")

</div>

Hello,

I have big database put to xml, it will be used in CD.  
A have a lot of xml files sorted alfabetical, I load them then client browse the info… but … I have to implement search.  
I cant search info without loading them all… and it takes too much time.  
The DB is HUGE.

POSIBLE SOLUTION:  
: create several new xml files to minimize search files… like index db… or something…  
lets say… search(“Lithunia”)

load text file … dbindex/lit.txt (first 3 leters…)  
(this .TXT contains list like… “A1241, J0051 …”  
that coresponds to files… [A1241.xml, J0051.xml …])  
then I load only thease files… which contains words that starts with “lit”

…

well it doesn’t solve the problem… at least not allways…

* * *

maybe you will have solution for big XML data searching problems…  
links…  
any ideas.

Thanks for your time.