Paul.Lee.1971 wrote:
> On 30 Jun, 00:56, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> Paul.Lee.1971 wrote:
>>> Hi everyone,
>>> I'm planning on using MySql/Php on either a Windows or, more likely, a
>>> Linux base. However, my database will be several thousands of records,
>>> in many hundreds of tables, searched using a "Search" query with a
>>> regex expression included. I'm wary about the speed penalties, and I
>>> would be very grateful if some metrics or timings could be
>>> provided....?
>>> Many thanks
>>> Paul
>>> --
>>> http://www.paullee.com
>> Paul,
>>
>> Thousands of rows is no problem. But "Hundreds of tables"? Even the
>> most sophisticated system I ever designed didn't require that many tables!
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================
>
> The problem I see is either hundreds of tables, or a table containing
> a huge amount of rows/columns!
>
If you properly normalize your database, you should need neither.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================