|
|
Posted by Miguel Cruz on 08/09/06 20:14
rcnews@gmail.com wrote:
> It sounds like Microsoft Access is not a favorite among programmers
> here.
And most other environments where people have been exposed to the
alternatives.
> That being said, I'm actually wondering if PHP is the best language to
> use for connecting our Access database to the website based on your
> comments? What I know is that we're currently using PHP (written by
> another technician) to have our website forms filter data into email
> accounts, so that the data can be manually entered later on in Access.
> You say it's possible, Kasper, to combine Access and PHP, but not that
> common.
I have done this (a few years back) and I didn't run into any particular
difficulties in terms of being able to make things happen.
However, at that time - and maybe things have changed - it seemed like a
lot of the relationalness of my queries was being handled by the ODBC
drivers or something, because queries that hit several large tables -
even if they didn't use very much of their data - resulted in huge
amounts of data traveling over the network.
As a consequence it ran at about 5% of the speed of a MySQL solution.
If you are just selecting rows by ID and that's it, then this doesn't
matter. But if your database structure is complex, and the behavior I
observed in 2001 is still the case now, then performance could be an
issue.
miguel
--
Photos from 40 countries on 5 continents: http://travel.u.nu
Latest photos: Malaysia; Thailand; Singapore; Spain; Morocco
Airports of the world: http://airport.u.nu
Navigation:
[Reply to this message]
|