|  IP: Logged

Hopefully he's just getting ready to put in a major update -- and then we can have many many more theatre tours to look at.

I do have a huge amount of new stuff for the site in my Inbox, but I must get my new theater opened first. Events started on Monday, and the public opening is on the 16th, just in time for Harry Potter. Yes, for those counting, that is three weeks of pre-insanity insanity!

But let me tell you -- when my couches show up in two weeks -- and I can begin finding a point to cleaning up this house -- I'll get some good stuff sent over to you.

A request: If anyone is using one of the monstrous state listing pages as a home page in your browser, please help me out with the bandwidth problem by using the main page (here) as your home page instead. Thanks!

If I ever get caught up on my inbox, I promise to get the database online. Hopefully, sometime this winter. Unless, of course, someone wants help me set it up for free.

 |  IP: Logged

 |  IP: Logged

quote:

---

Anybody know PHP and MySQL? I really need to get this thing on a live database to ease up the bandwidth.

---

How will this ease up your bandwidth usage?

quote:

---

I have arranged for another subdomain to be opened up, and I should have the site rearranged with this weekend's update.

---

If you have used (or would change to) relative links or links starting from the domain base (links starting with a forward slash) you could just mirror the entire site (instead of trying to do a 'balanced re-organization') on both domains and then use a cgi script to do a quasi load balance by sending every other user to the sub-domain. This would work really good if you put the whole site in a single full page frame, but is not absolutely necessary.

You might also want to look into hosting at tera-byte dot com ( here ) they've been around for 'a long time'. I've used them for some stuff for the past few years and only have experienced 6 minutes of total downtime (at about 3:00am) for a backup power generation upgrade. Their website says $55/US for 50GB monthly.

quote:

---

How will this ease up your bandwidth usage?

---

I shall use the state of California as an example. Currently, when a user loads the California page, it displays all 1876 theaters and 678 photos. If I use a live database, I can set it up to break the page into easy-to-chew 100 theater groups to display, with links to "jump to page x" or "jump to city x". The California page is about 1.5MB of html plus photos as it is now. That's where the bandwidth is to be saved.

It will also allow "staff" to sign in and see things not available to the general public without me having to produce (and upload) two different pages like I'm doing now.

As far as using relative links, I'm using DOS-type links now ( ../../whatever/blah. htm ) so that I can easily do all of my work on my PC without having to run Apache to view the pages while I'm working. I also work off of my laptop (very important on the road!) and the PC at work (don't tell my boss -- he thinks its corporate email! ), and occasionally produce a CD-ROM version of the entire site for "staff" that can be run on any PC.

When the site goes database, I can still use my current DOS-based crappy old database to do my work on, but export through a text file to the MySQL database online for the once-a-week update. I like the crappy old database because I am fluent in its odd scripting language and everything I use is a custom script. I don't have time to learn how to use a new database.

 |  IP: Logged

 |  IP: Logged

 |  IP: Logged