how to maintain database

currently i have 3 databse , one for eod data . one for historical ieod data (5yrs) and one for current 2 months data ......for ncdex , mcx and fno ...........

if i merge all data in one ..........than when feeding data to it , it gets freezed and not responding ............
i want that my eod and ieod get merged so that when i ever i analysis my charts than all marking remains in one chart only , as currently i do same work in all three databse ......

so what will be right option for managing database .......
1) all seperatlely maintained ...
2) mix eod and six months ieod.....
3) or any other option by which historical ieod and eod get merged and database not freeze ........

I am not very techno savy or knowledgeable about Computers or softwares but feel that one cannot merge EOD and IEOD database. The reason I feel is very obvious. Dont know how to explain it.
From IEOD data you can get an EOD chart but not the other way round.
So your Option 1 : Maintain separately should be the ONLY option for you.

thank you sir , but sir than how to analyze charts ...........
if we draw sr lines trendlines on eod than how we get automatically it on ieod chart ?
we have to again draw on ieod chart but as it has limited data than how we draw on it (historical trendline , sr lines )?
sir , in ami , in my knowledge there is a option of mix ieod and eod data .........

sir in metastock can we mix both of them ?
also how much historical ieod data can be stored and runs smoothly in metastock ?

Not sure, maybe you need to post your query in some Amibroker thread. Maybe its possible to Plot an EOD and IEOD chart in same window but different sections.

I am probably not understanding what you mean to say " mix both of them" !

In metastock one can have max 65500 records for a Security. This amounts to approx : 200 days IEOD data of 1 min TF or 1000 days data in 5 min TF !
OR over 200 years data of EOD !

Smooth running of data depends on the number of indicators etc used in a chart. For vanilla charts it would depend on RAM etc.

In metastock one can draw the SR lines in say 60 minutes chart and change the setting to Daily and still have the lines SR showing provided enough data is there.

in my eod database , i insert my ieod database (first i change ieod into csv format than i by import ascii i send it to eod database).............whole eod database got corrupt !!!
plz help me , not what to do ???

You can combine eod with ieod which eod data u using yahoo or nse ?
u manually import data ieod data ?
My self I use combine data eod from (nse) downloaded from getbhavcopy.
ieod from amiquote no seperate database needed for that.When using some realtime datafeeder there may be lost in data