[thelist] Practical limits for MySQL + PHP

[Hans Zaunere]

http://www.mysql.com/articles/index.html

and specificaly

http://mysql.com/articles/us/yahoo_finance.html

There is no inherent reason why MySQL couldn't handle records like
this.  You should of course read about tuning MySQL's system variables
to best suite the type of queries you are doing, and optimize your
queries/locking accordingly.

As for the PHP side, MySQL will handle all the data, so this isn't an
issue.  If you need to do large data manipulation, you might want to
think about running PHP outside of Apache, and use temp. tables as a
cache (if RAM permitts).

You shouldn't have any problems.

Hans Z.
New York PHP
http://nyphp.org


--- Jay Blanchard <jay.blanchard at niicommunications.com> wrote:
> Good Friday!
>
> In the office we are discussing a rather large reporting project that
> involves the addition of thousands of records per day to a MySQL
> database.
> The database could contain as much as 40 million records in any given
> 3
> month time period. Items more than 90 days old would be
> "highlighted/summarized" into a different table. We have various
> methods of
> providing reports but are interested in using a web-based PHP
> interface to
> delivery some of the reports. Has anyone come up against the
> practical
> limits of doing reporting with recordsets potentially this large?
> There are
> some things I can do to maximize performance such as creating views
> of
> certain datasets and querying the view or creating an UDF which runs
> the
> query periodically and outputs to file that can be updated
> periodically
> during the day. Ad hoc queries are a particular concern, as the users
> of the
> reports may want to run certain date ranges, etc.
>
> TIA!
>
> Jay
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !


__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/