jasonsalas
IS-IT--Management
Hi!
I was thinking about ways in which to change the way we generate our articles for my site...a news site:
I've been using basic DB calls which generate articles by querying a specific record within my Access 2000 DB:
I'd like to develop a schema wherein our database can dynamically generate real, physical files with URLs like (these don't really exist):
I've got something like this running already on my MSNBC.COM affiliate site - - but MSNBC set that architecture up themselves, using XML files I upload to their server...at which point the files are created on the server. I guess I just want to know how to do this, too. It's much easier and much less work this way.
My main focus for this is to increase the chaces by which our site is recognized by the major search engines (i.e., Google, Excite, Lycos) and Web directories (i.e., Snap, Yahoo!). Since I cut our site over to be database-driven, our existence in search engines is much less...and I haven't got the budget to spend on the big search services.
It'll also be easier to integrate MS Index Server for our intra-site search utility if the files are physical and sit on my server (Index Server doesn't do such a good job with queries files). Again, I'm running Access 2000, but I can switch to SQL Server 7 if necessary.
Maybe the question should be----is this even the best way to go about this?
I was thinking about ways in which to change the way we generate our articles for my site...a news site:
I've been using basic DB calls which generate articles by querying a specific record within my Access 2000 DB:
I'd like to develop a schema wherein our database can dynamically generate real, physical files with URLs like (these don't really exist):
I've got something like this running already on my MSNBC.COM affiliate site - - but MSNBC set that architecture up themselves, using XML files I upload to their server...at which point the files are created on the server. I guess I just want to know how to do this, too. It's much easier and much less work this way.
My main focus for this is to increase the chaces by which our site is recognized by the major search engines (i.e., Google, Excite, Lycos) and Web directories (i.e., Snap, Yahoo!). Since I cut our site over to be database-driven, our existence in search engines is much less...and I haven't got the budget to spend on the big search services.
It'll also be easier to integrate MS Index Server for our intra-site search utility if the files are physical and sit on my server (Index Server doesn't do such a good job with queries files). Again, I'm running Access 2000, but I can switch to SQL Server 7 if necessary.
Maybe the question should be----is this even the best way to go about this?