Hi Friends,
I work for a software company .Iam at present working in a module in my companies project .
To see the project online kindly visit
http://www.buddiesinfotech.com/faithlinks/
in this page you will see many links under headings such as SPIRITUAL GROWTH,ONLINE INFORMATION etc... the site has around 3500 links total and i bring everything from the mysql db and then the javascript is done.
The problem i face is that .. since all the links are from the db
1) The site is very very slow in its development stage in the above link.So in future, If many users connect to the db when the site is made live .. then the site will become more slower.
2) Even if its slow the site loads fully in some of the machines.. but the major problem is that in some machines the links area never load at all.That too bad.
How can this be solved ? should i try to change the queries ? or
shall i use XML ? I will have a global variable in the server and store everything in the memory and ill use the cronjob to update the variable everyday if new links are added. Is this idea anything kind of usable ?
any better suggestions on this ?
Kindly assist me in this regard.
Thanks Everybody
Shankar
