How Much Slower Does PHP/mySQL Run on Windows?

Any slower than running a query on Microsft Access?

[dougmcc1]

I have a couple tables in Microsft Access '97 with hundreds of thousands of records that I routinely run queries off of which I then paste into Excel to make changes, and then paste back into the database.

I want to switch to a brower-based system to simplify things but I'm running on Windows. If I install PHP/mySQL, will it process the queries slower than the Access database?

Thanks.

[StupidScript]

Absolutely not! (IMHO)

The PHP/MySQL combination is much faster than MS Access alone. In addition, as of v.5, MySQL (finally) supports stored procedures, like MS SQL Server does.

The biggest limitation to MySQL would be the operating system. Here's a quick reference. Compare it to Access's 2GB maximum-useable (or ~400MB before it starts to slow down noticeably) db file-size:

OS : File-size Limit

Linux 2.2-Intel 32-bit : 2GB (LFS = 4GB)
Linux 2.4 (ext3) : 4TB
Solaris 9/10 : 16TB
Netware (NSS) : 8TB
win32 (FAT/FAT32) : 2GB/4GB
win32 (NTFS) : 2TB (possibly larger)
Mac OSX (HFS+) : 2TB

As far as speed goes, there's simply no question that PHP/MySQL running under Apache are much faster than Access 97 with regard to running queries.

Please report back with how your porting of the Access db to MySQL went. That's a big problem for our company.

[dougmcc1]

Thanks for the reply. I wonder if I'd get the same answer in the Microsoft forum? :)

By porting, do you mean transferring the data from Access to mySQL? It was easy, in Access you can export the data as a text file (choose semicolon as the deliminator), and phpMyAdmin allows you to import the text file. I was able to transfer about 120,000 records in minutes.

[StupidScript]

Good work. Our company's MS Access database has all sorts of queries and macros and forms and so on, which have proven to be extremely troublesome.

BTW, I'm certain visitors to an MS forum would agree with my assessment. ;)

[dougmcc1]

queries

Oh yeah, copying the queries might prove difficult because I think Access uses a little bit different SQL syntax than mySQL does. I think the table structure is even different. Converting the macros to PHP... good luck.

MS form

Thanks for the reassurance :)