Search data from the database
-
My requirement is to search the data from the database.But here one problem is whenever I click for search the data,It will take the trip to database server.Instead of that Is there any other solution where I can keep my data from database and search for it.. 1.Is it possible to do with transfer the data to XML file and search in tht only? 2.Or there is another solution to do this? Please help me..
Hi, does the query took to long? Maybe you are retrieving too many results to display? 1. Why do you convert the data into XML? XML-processing is slow and should only be used with small amounts of data. 2. You could use different approches to speed up your site (caching etc.) but for this we need to know more about the architecture/code you are using at the moment. Maybe you could go into more detail... Regards Sebastian
It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.
-
Hi, does the query took to long? Maybe you are retrieving too many results to display? 1. Why do you convert the data into XML? XML-processing is slow and should only be used with small amounts of data. 2. You could use different approches to speed up your site (caching etc.) but for this we need to know more about the architecture/code you are using at the moment. Maybe you could go into more detail... Regards Sebastian
It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.
1.Basically whatever the solution , it should be applicable to the search the data which will be in small or huge amount.. 2.My requirement is as follows: i)There will be an admin user who will add the data for the site. ii)Requirement is like,when admin will add the data tht time only XML file will get updated.Otherwise search will done from XML file with the data present at tht time. Basically I want to ignore the trip to the database server... If you are talking about the caching is it feasible solution for it?
-
Deepml wrote:
1.Is it possible to do with transfer the data to XML file and search in tht only?
Yes you can. at load time make XML and then search only that XML.
Deepml wrote:
2.Or there is another solution to do this?
You can use ajax to search data.
Viral My Site Tips & Tracks
-
Put search button and result in update panel. so your whole page will not post back.
Viral My Site Tips & Tracks
-
Put search button and result in update panel. so your whole page will not post back.
Viral My Site Tips & Tracks
I think you didnt understand my requirement..I dont hv any problem wid the page postback.. My requirement is as follows: i)There will be an admin user who will add the data for the site. ii)Requirement is like,when admin will add the data tht time only XML file get updated.Otherwise search will done from XML file with the data present at tht time. Basically I want to ignore the trip to the database server...
-
My requirement is to search the data from the database.But here one problem is whenever I click for search the data,It will take the trip to database server.Instead of that Is there any other solution where I can keep my data from database and search for it.. 1.Is it possible to do with transfer the data to XML file and search in tht only? 2.Or there is another solution to do this? Please help me..
You can use indexing technique to make your search fast and convinient. For that you have to create indexes and your searches will be on indexes only rather than actual data which will increase the speed of searching Thank You
Vinod Kumar Prajapati Software Engineer EBC Publishing Pvt. Ltd.
-
1.Basically whatever the solution , it should be applicable to the search the data which will be in small or huge amount.. 2.My requirement is as follows: i)There will be an admin user who will add the data for the site. ii)Requirement is like,when admin will add the data tht time only XML file will get updated.Otherwise search will done from XML file with the data present at tht time. Basically I want to ignore the trip to the database server... If you are talking about the caching is it feasible solution for it?
Is your data stored within an XML file? If yes, I would suggest switching to a database, because that will be much faster, easier to use etc...
It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.
-
My requirement is to search the data from the database.But here one problem is whenever I click for search the data,It will take the trip to database server.Instead of that Is there any other solution where I can keep my data from database and search for it.. 1.Is it possible to do with transfer the data to XML file and search in tht only? 2.Or there is another solution to do this? Please help me..
The solution is to use an external indexing server as described here for instance: see here[^] Page 11 has a nice system chart... It will speed thinks up and make it possible to automate the data updates between the database and the data used by your AJAX servlet. Does this help? Let me know if you need help. Dan - rastaquere AATT gmail DOTT com
-
You can use indexing technique to make your search fast and convinient. For that you have to create indexes and your searches will be on indexes only rather than actual data which will increase the speed of searching Thank You
Vinod Kumar Prajapati Software Engineer EBC Publishing Pvt. Ltd.
-
Is your data stored within an XML file? If yes, I would suggest switching to a database, because that will be much faster, easier to use etc...
It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.