RE: [cobalt-users] Raq550 : MySQL performance question

["Phil Beynon" <phil@xxxxxxxxxxxxxxxxxxxxxxxxx>]

> Hi Folks,
>
> A customer called me last week and asked me if I could write some
> php/mysql
> script that queries a 200MB database (and growing)
> And if I could host such things on one of our raq550's (a real 550).
> The fact that it's a 200MB DB with more than a million records (pricelists
> of parts) possibly being queried by up to 20 dealers at the same
> time scares
> me a bit to give a go to this project.
> Does anyone have experience with large MySQL DB's on raq's ? What about
> performance ?
> Can it be done on a shared hosting raq with other DB's or should
> I consider
> a dedicated raq.
> Is a raq550 to be considered as a solution at all?
> Thanks in advance.
>
> John

John,
200Mb isn't really all that large, we run some pretty big tables on a 4i and
it copes quite nicely.
Mostly it is the nature of the actual SQL query and the way it's been
written that governs the efficiency of the way it runs.
You can easily set up the tables and run from the mysql command line to see
the execution time of the query as a tryout to see what sort time it takes.
20 users at the same time isn't a lot!

Phil

** http://www.diygear.com THE Online DIY Toolstore For DIY & Business
** Infolink Electronic Systems Ltd. http://www.infolinkelectronics.co.uk
** Professional Web Design & Cobalt Hosting Solutions
** Sun Cobalt iForce Reseller - Canon Silver Reseller
** Contact: Sales@xxxxxxxxxxxxxxxxxxxxxxxxx
** Tel / Fax 0121 458 4894 (office) 0121 441 3558 (home)