|
|
Posted by J.O. Aho on 10/10/39 11:48
Frankly wrote:
> "J.O. Aho" <user@example.net> wrote in message
> news:4djhbkF1ah9mqU1@individual.net...
>>> I know I am not the fasted index in a database but are you using the
>>> relationManagementBuilding table as a linking table to create a Many to
>>> Many relation?
>> Yes, thats right, a good idea is to make the ManagementID and BuildingID
>> to be the primary key, this way you won't get doublets.
>
>
> I am thinking that ManID and BuildingID are the primary keys in their tables
Yes, that is right and a good way to do.
> and that the linking table does not get a primary key.
It should still have "a" primary key that is the two ID's together, other wise
you can have doublets in the link table, which you don't want.
> at least now the database will show the changes on the website. and
> returning customers can see my daily upgrades even if they dont clear their
> browsers cache. I like using the forms in Access
> they make it very easy to copy and paste data on web sites where I post her
> ads.
You can export and import in mysql (and other full sql servers), which makes
it easy to move data from one database to another.
>>> If I am able to do the MySQL install on my own I wonder how long it
>>> would take.
>> To install things on your own computer won't take long, there are packages
>> for microsoft that includes apache (web server), php and mysql. For doing
>> installation on web hotels, you will need to have admin access on them,
>> which are only for employees on the company hosting the web hotel.
>
> I work out of my apartment and I do have 3 computers. I wouldnt want to
> create a web server
> on the newer computers for fear of hackers. I dont even have them networked
> together.
> I guess I could install it on my lap top. Its originally had windows 98 and
> is now suffering with windows XP.
If you dare, you could take the step over to the unix world and install
GNU/Linux or BSD of some kind, you will most often get a package manager that
will help you keep your machine up to date and have quite recent versions of
apache, mysql and php installed. IMHO an unix like OS is a lot better fit for
server work than microsoft is (even microsoft uses BSD and Linux for servers).
I know many microsoft users who sets up a home server using Linux, installs a
desktop version with the server applications they want to use, this is vast of
CPU power, as the X Window system will use up many CPU cycles and memory too,
which better could be used on the server applications. For decent server
distros, take a look at SoL www.sol-linux.com, Trustix www.trustix.net or
Gentoo www.gentoo.org. I think SoL and Trustix are best options, Gentoo does
offer more packages, but requires more from the user and in some cases forces
you to do some serious hacking as the maintainers don't make good choices.
//Aho
Navigation:
[Reply to this message]
|