View Single Post
  #6 (permalink)  
Old 04-22-2008, 04:54 PM
B0B B0B is offline
WebProWorld New Member
 

Join Date: Aug 2004
Location: Anaheim California
Posts: 16
B0B RepRank 0
Default Re: Need help with making a website

PHP and MySQL or .NET and any database will work. I like .NET.
My only concern is database size.

I envision two tables.
One with the list of clients including a client ID with all the information about the client, links etc.
The second for visited links. It should contain two columns. The client ID doing the visiting and the Client ID that was visited.
For each client table entry there is potentially a visited table entry for every client.
The number of entries in the visited table is potentially the square of the client table entries.

How many clients will you have and what is their usage?
If you have 1,000 clients and each averages 10 visits to other clients the visited table would only contain 10,000 entries.
However, if you have 1,000 clients and they all visit the other clients the visited table would contain 1,000,000 entries. The visited table grows exponentially.

This type of link visitation scheme is susceptible to visitation automation. It wouldn’t be hard to write a program that visits every client.
I suggest you put a link on the pages to be visited that isn’t easily recognizable by a bot and use that link as verification that the site was visited. You might even employ a timer to ensure people stay a minimum time.

If you have any questions email me using bob@ and my URL

Enjoy Bob
Reply With Quote