How to convince my boss that MySQL/PHP are better than EXCEL

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

User avatar
TheMoose
Forum Contributor
Posts: 351
Joined: Tue May 23, 2006 10:42 am

Post by TheMoose »

timvw wrote:- And exactly what makes you believe that a webapplication will deliver the reduced look-up time?
He had originally said that:
when someone is trying to get some specific employee information its a problem because there is not a single place to check this information.
That tells me that there is no single storage medium for ALL the data, and his boss's solution is to merely synchronize employee info. My perception of syncing in this manner is just syncing all the data that is the same field, ie names, addresses, not have all the data stored in 1000 places. That would defeat his bosses entire purpose of having it in multiple excel files and access db's.

If you design it properly, and have all the data readily available, how does it not reduce lookup time? Besides, have it stored in multiple locations puts greater strain on a potential backup solution, whereas a single, central db can be backed up easily.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Keep in mind that you still need to contend with files vs. data. Files are files, and servers have filesystems so files can be managed on the file system. Databases can store files, but they are much better at storing/retrieving/modifying data.
kingconnections
Forum Contributor
Posts: 137
Joined: Thu Jul 14, 2005 4:28 pm

Post by kingconnections »

Also, Excel files that use links and access outside data sources tend to have issues and go corrupt. I worked for a large company and they are always having issues with excel files that are really over grown applications.
User avatar
jyhm
Forum Contributor
Posts: 228
Joined: Tue Dec 19, 2006 10:08 pm
Location: Connecticut, USA
Contact:

Post by jyhm »

Or you could just rip that old bast**d a new one
and say "ridem' cowboy there's a new sherif in town partner!"

Ye Haw! just like, Los vaqueros! :wink:

EDIT: Notice Wink,..
Post Reply