3500 links from mysql DB
Posted: Sat Nov 08, 2003 6:14 pm
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.Thats too bad.
How can this be solved ? should i try to change the queries ? or should i brind in the data from a txt file ..etc ?
any better suggestions on this ?
Kindly assist me in this regard.
Thanks Everybody
Shankar
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.Thats too bad.
How can this be solved ? should i try to change the queries ? or should i brind in the data from a txt file ..etc ?
any better suggestions on this ?
Kindly assist me in this regard.
Thanks Everybody
Shankar