NONE: Re: ONLINE-ADS>> Indexing Databases
Re: ONLINE-ADS>> Indexing Databases
william suboski (suboski_at_adan.kingston.net)
Thu, 13 Feb 1997 01:13:52 -0600
I had to respond to this, as it touches on issues that I have been addressing...
>Early in 1995, I consulted with a company that wanted to put its database on
>the Web. We decided to go with static pages and pre-generated indices rather
>than database queries on-the-fly. This meant faster access time, no
>programming on the server, lower cost for software, and easy extension from
>the client's current database. This method can work if you have only a few
>simple queries and a good search engine.
I have used this same method, but for slightly different reasons. To create
pages on a PC requires only a small computer program, the keys can be
whatever is desired, in fact there can be multiple keys, and given FTP, each
client can manage their own site, and therefore not depend on the
responsivity of an ISP. I strongly recommend this approach if you are not
running your own server (and most people aren't!)
>One of the unanticipated benefits
>of this approach was that the site is all over the search engines' indices.
>When you search any of th e major search engines for keywords that are found
>in the database, you'll find hundreds of hits for my client, one for each of
>the pre-generated pages and one for the index page. We didn't do this to
>intentionally "stuff" the search engines, but because of the way
>spider-driven search engines work, it had that side effect.
I too had this pleasant discovery. One of my clients is a real estate agent.
My program puts the address, Kingston, Ontario, Canada, in the title of all
of her pages. This means that she pops out in searches keyed on Kingston.
Very desireable in her line of business...naming the page is an art unto itself.
>So you might think again about creating Web pages on-the-fly. There are
>definite advantages to a well-conceived pre-generated index, even if you
>have many megabytes of data.
I agree. My real estate client doesn't want people entering criteria, and
having properties automatically excluded; instead, she wants potential
buyers to be able to browse all of her listings.
Bill
Bill Suboski - Internet Smokejumper suboski_at_adan.kingston.net
http://www.kingston.net/suboski 613-531-8227
Interactive Pictures http://www.kingston.net/suboski/lab2.html
-------------------------------------------------------------------------
This week's Online Advertising Discussion List sponsors:
Q: How can I maximize my Web site's revenues from banner advertising?
A: Don't carry unsold, excess ad space. Sell out every impression.
adbot: the auction market for internet advertising (tm) http://www.adbot.com/
---------------
WEB ADVERTISING '97: How to Bring the World to Your Web Site
Make your web ads *work*
http://www.thunderlizard.com/ola.html 800/221-2806
-------------------------------------------------------------------------
Online Advertising Discussion List To Unsubscribe send UNSUBSCRIBE
http://www.o-a.com/ to online-ads-request_at_o-a.com
