|
|
Posted by Brian Wakem on 11/20/57 11:36
John Bokma wrote:
> Charles Sweeney <me@charlessweeney.com> wrote:
>
>> John Bokma wrote
>>
>>> Charles Sweeney <me@charlessweeney.com> wrote:
>>>
>>>> John Bokma wrote
>>>>
>>>>> "Paul Watt" <paulio@wattioNOSPAM.freeserve.co.uk> wrote:
>>>>>
>>>>>> Hi Guys,
>>>>>> I'm using PhpBB and I want to customise it to fit it seamlessly
>> with
>>>>>> my site. I dont want to use an iFrame to integrate it. my question
>> is
>>>>>> do I have to mess around with the subsilver templates or do I have
>> to
>>>>>> alter the PHP index file?
>>>>> The former, and be prepared for a lot of "fun"
>>>> Particularly at upgrade time!
>>> Don't get me started
>> LOL!! I share your pain!
>
> Another painful experience was when I convinced a friend to drop her
> friend as a hosting solution, also because you could use phpmysqladmin (or
> whatever it's called) without a password (!).
>
> Anyway, uploading a phpbb database to a new host turned out not to be a
> piece of cake. I have no idea why uploading a mysql database with 100,000+
> records should take a lifetime and more. (The webbased thingies couldn't
> handle it, so I connected with the mysql client, hurray for the CLI).
>
> If anyone has tips to speed things up?
>
> i.e mysql -ufoo -p -database bar < dump.sql takes ages and ages, even
> locally. I know that the inserts are done one by one (not the smart way),
> but why my harddisk is spinning for 20-30 minutes when I do something like
> this is beyond me. Can't remember that it was that slow in the past.
>
This isn't going to help, but I get between 5000 and 10000 inserts per
second on our server when doing that.
Did it have a full-text index by any chance?
--
Brian Wakem
Email: http://homepage.ntlworld.com/b.wakem/myemail.png
Navigation:
[Reply to this message]
|