Webmaster forum - Looking for someone to help improve website performance

Author

Looking for someone to help improve website performance

Epetruk

2007-11-17, 10:16 pm

Hi,

Does anyone here know if there are companies, consultants, etc. who would be
prepared to look at a site that was performing very slowly (e.g. slow page
loads, site crashes, etc.) and recommend and implement measures to speed up
performance? Can anyone recommend a particular consultant or company?

Thanks in advance,

Akin
--
akyak at aksoto dot idps dot co dot uk

--
Posted via a free Usenet account from http://www.teranews.com

Rob Waaijenberg

2007-11-18, 6:15 am

Epetruk schreef:
> Hi,
>
> Does anyone here know if there are companies, consultants, etc. who would be
> prepared to look at a site that was performing very slowly (e.g. slow page
> loads, site crashes, etc.) and recommend and implement measures to speed up
> performance? Can anyone recommend a particular consultant or company?
>
> Thanks in advance,
>
> Akin

Have you tried usenet?

You don't pay anyone,
you get a lot of different opinions (with luck you also get arguments),
you make new friends (if you pay attention to their advices),
you learn a lot of new things fast.

On the negative side:
you have to read a lot,
people will say things you don't want to hear,
you may not understand everything that is being posted.

But it is the best thing you can do, for now.

--
Rob

dk_sz

2007-11-18, 6:17 pm

Hi,

> Does anyone here know if there are companies, consultants, etc. who would
> be prepared to look at a site that was performing very slowly (e.g. slow
> page

In most cases I would look at your database SQL
queries first. Unless you have really complicated code
touching lots of files in loops gone bad (hehe), it is poor
SQL queries that can kill performance.

--
best regards
Thomas Schulz
:: A1 Sitemap Generator now ::
http://www.micro-sys.dk/products/sitemap-generator/

Epetruk

2007-11-18, 6:17 pm

"Rob Waaijenberg" <robwaaijenberg@hotmail.com> wrote in message
news:47401933$0$227$e4fe514c@news.xs4all.nl...
> Epetruk schreef:
>
> Have you tried usenet?
>
> You don't pay anyone,
> you get a lot of different opinions (with luck you also get arguments),
> you make new friends (if you pay attention to their advices),
> you learn a lot of new things fast.
>
> On the negative side:
> you have to read a lot,
> people will say things you don't want to hear,
> you may not understand everything that is being posted.
>
> But it is the best thing you can do, for now.
>
> --
> Rob
>

Hello Rob,

I *am* trying Usenet - that's why you can see this. :)

Seriously, I don't have the luxury of time to do this myself - I only help
out. And I don't have the development tools to enable me to understand what
is going on in a php/mysql environment. I'm just helping the webmaster do
some research here.

Can you help? Would you be willing to help if we made it worth you while,
i.e. ??????? Do you know anyone else who would?

Thanks,

Akin
--
akyak at aksoto dot idps dot co dot uk

Epetruk

2007-11-18, 6:17 pm

"dk_sz" <dk_sz@hotmail.com> wrote in message
news:47401f16$0$2103$edfadb0f@dtext02.news.tele.dk...
> Hi,
>
>
> In most cases I would look at your database SQL
> queries first. Unless you have really complicated code
> touching lots of files in loops gone bad (hehe), it is poor
> SQL queries that can kill performance.
>
>
> --
> best regards
> Thomas Schulz
> :: A1 Sitemap Generator now ::
> http://www.micro-sys.dk/products/sitemap-generator/
>

Hello Thomas,

This is a very good suggestion. The problem is that I don't have the time or
tools to properly analyse query performance. As I said in my reply to Rob,
I'm just helping the webmaster do research on this matter.

Can you help? Would you be willing to help if we paid you to do so? Do you
know anyone else who would? How much do you think this would cost?

Thanks in advance,

Akin
--

Epetruk

2007-11-18, 6:17 pm

"Epetruk" <nobody@blackhole.com> wrote in message
news:Vw_%i.138904$PQ6.76913@newsfet01.ams...
>
> "Rob Waaijenberg" <robwaaijenberg@hotmail.com> wrote in message
> news:47401933$0$227$e4fe514c@news.xs4all.nl...
>
> Hello Rob,
>
> I *am* trying Usenet - that's why you can see this. :)
>
> Seriously, I don't have the luxury of time to do this myself - I only help
> out. And I don't have the development tools to enable me to understand
> what is going on in a php/mysql environment. I'm just helping the
> webmaster do some research here.
>
> Can you help? Would you be willing to help if we made it worth you while,
> i.e. ??????? Do you know anyone else who would?
>
> Thanks,
>
> Akin
> --
> akyak at aksoto dot idps dot co dot uk
>

Sorry Rob, I meant those question marks to show up as Euro signs. :)

Akin

Jerry Stuckle

2007-11-18, 6:17 pm

Epetruk wrote:
> "dk_sz" <dk_sz@hotmail.com> wrote in message
> news:47401f16$0$2103$edfadb0f@dtext02.news.tele.dk...
>
> Hello Thomas,
>
> This is a very good suggestion. The problem is that I don't have the time or
> tools to properly analyse query performance. As I said in my reply to Rob,
> I'm just helping the webmaster do research on this matter.
>
> Can you help? Would you be willing to help if we paid you to do so? Do you
> know anyone else who would? How much do you think this would cost?
>
> Thanks in advance,
>
> Akin

Akin,

That's been my experience, also. Improve the mysql performance and you
improve a lot of things.

However, the cost is impossible to estimate. It's like asking someone
to fix the plumbing in your house. What kind of estimate can they give
if they haven't seen your house, haven't determined why your water
pressure is low, what they have to change to fix it... and the list goes on.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Epetruk

2007-11-18, 6:17 pm

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:79CdnRvaMqke593anZ2dnUVZ_uyinZ2d@comcast.com...
> Epetruk wrote:
>
> Akin,
>
> That's been my experience, also. Improve the mysql performance and you
> improve a lot of things.
>
> However, the cost is impossible to estimate. It's like asking someone to
> fix the plumbing in your house. What kind of estimate can they give if
> they haven't seen your house, haven't determined why your water pressure
> is low, what they have to change to fix it... and the list goes on.
>

Hi Jerry,

Thanks for responding.

OK, I'm pretty keen on helping the webmaster to resolve this problem, so
I'll accept any suggestion and follow it through.

Can you (or anyone else reading this) help me answer the following
questions:

- Is there a way of logging the mysql queries that are run, and how long
they take?

- Does mysql allow for column indexing to speed up querying? (OK, I know I
can find out more on alt.php.sql, but a quick answer would help)

- Is there anything other simple step I can take to speed up queries run
agains the mysql database, other than eliminating unnecessary queries?

Thanks very, very, very much in advance.

Akin

--
akyak at aksoto dot idps dot co dot uk

Rob Waaijenberg

2007-11-18, 6:17 pm

Epetruk schreef:
> "Rob Waaijenberg" <robwaaijenberg@hotmail.com> wrote in message
> news:47401933$0$227$e4fe514c@news.xs4all.nl...
[][color=darkred]
[color=darkred]
> Hello Rob,
>
> I *am* trying Usenet - that's why you can see this. :)
>
> Seriously, I don't have the luxury of time to do this myself - I only help
> out. And I don't have the development tools to enable me to understand what
> is going on in a php/mysql environment. I'm just helping the webmaster do
> some research here.
>
> Can you help? Would you be willing to help if we made it worth you while,
> i.e. ??????? Do you know anyone else who would?
>
> Thanks,
>
> Akin

OK, when I write this, you've already had several other reactions.
And your SQL-queries have been mentioned as a possible source of trouble.

Maybe posting an URL can help us help you.

--
Rob

Jerry Stuckle

2007-11-18, 6:17 pm

Epetruk wrote:
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
> news:79CdnRvaMqke593anZ2dnUVZ_uyinZ2d@comcast.com...
>
> Hi Jerry,
>
> Thanks for responding.
>
> OK, I'm pretty keen on helping the webmaster to resolve this problem, so
> I'll accept any suggestion and follow it through.
>
> Can you (or anyone else reading this) help me answer the following
> questions:
>
> - Is there a way of logging the mysql queries that are run, and how long
> they take?
>
> - Does mysql allow for column indexing to speed up querying? (OK, I know I
> can find out more on alt.php.sql, but a quick answer would help)
>
> - Is there anything other simple step I can take to speed up queries run
> agains the mysql database, other than eliminating unnecessary queries?
>
> Thanks very, very, very much in advance.
>
> Akin
>

Akin,

Actually, comp.databases.mysql is a much better group. But they'll tell
you the same thing over there - without determining where the
performance bottleneck is, it's impossible to make meaningful
suggestions on how to fix it. Shooting in the dark isn't likely ti fix
anything.

And yes, there is a long query log, but that's typically for queries
which take a while, i.e. 5 seconds or more. I doubt any of your queries
take nearly that long.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Epetruk

2007-11-18, 6:17 pm

"Rob Waaijenberg" <robwaaijenberg@hotmail.com> wrote in message
news:4740a4e9$0$239$e4fe514c@news.xs4all.nl...
> Epetruk schreef:
> []
>
>
>
> OK, when I write this, you've already had several other reactions.
> And your SQL-queries have been mentioned as a possible source of trouble.
>
> Maybe posting an URL can help us help you.
>
> --
> Rob

Sure, Rob.

It's http://www.nigeriavillagesquare.com.

Akin

--
akyak at aksoto dot idps dot co dot uk

Jerry Stuckle

2007-11-18, 6:17 pm

Epetruk wrote:
> "Rob Waaijenberg" <robwaaijenberg@hotmail.com> wrote in message
> news:4740a4e9$0$239$e4fe514c@news.xs4all.nl...
>
> Sure, Rob.
>
> It's http://www.nigeriavillagesquare.com.
>
> Akin
>

Well, to start with:

Your home page is 740K bytes, of which over 580K is images. Not to
mention another 60K of javascript. It's going to be slow.

MySQL isn't where you should be spending your time right now.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

1001 Webs

2007-11-18, 10:17 pm

On Nov 18, 10:25 pm, "Epetruk" <nob...@blackhole.com> wrote:
> "Rob Waaijenberg" <robwaaijenb...@hotmail.com> wrote in message
>
> news:4740a4e9$0$239$e4fe514c@news.xs4all.nl...
>
>
>
>
>
>
>
>
>
>
>
>
>
> Sure, Rob.
>
> It'shttp://www.nigeriavillagesquare.com.

What the heck is this for?:
<META http-equiv=Page-Exit content=BlendTrans(Duration=0)>
<META http-equiv=Page-Enter content=BlendTrans(Duration=0)>
???

You shouldn't rely on fake AJAX tricks. If that was of any help I'm
sure Joomla developers would have implemented it already.
All that FAJAX fake code (i.e. IE page transitions to make your
dynamic pages look as if you were using Ajax) is doing is sending
illegal unsupported methods to the server for processing on IE
browsers (but no use on others).
Several server round trips are often required thus making your pages
as slow as they can get.

Take those 2 lines out and see if page loading speeds up.
It should speed up, noticeably.

Chaddy2222

2007-11-19, 3:17 am

On Nov 19, 11:21 am, 1001 Webs <1001w...@XXXXXXXXXX> wrote:
> On Nov 18, 10:25 pm, "Epetruk" <nob...@blackhole.com> wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> What the heck is this for?:
> <META http-equiv=Page-Exit content=BlendTrans(Duration=0)>
> <META http-equiv=Page-Enter content=BlendTrans(Duration=0)>
> ???
>
> You shouldn't rely on fake AJAX tricks. If that was of any help I'm
> sure Joomla developers would have implemented it already.
> All that FAJAX fake code (i.e. IE page transitions to make your
> dynamic pages look as if you were using Ajax) is doing is sending
> illegal unsupported methods to the server for processing on IE
> browsers (but no use on others).
> Several server round trips are often required thus making your pages
> as slow as they can get.
>
> Take those 2 lines out and see if page loading speeds up.
> It should speed up, noticeably.- Hide quoted text -
>
Perhaps, but your more likely to get better results if you properly
optomise images.
As an example all the images should be below 30kb in order for them to
load in less then 8 seconds on a dial-up conection not to mention to
save bandwidth on broadband. Some of us get charged by the MB. I know
Deakin (my university) do such a thing.
--
Regards Chad. http://freewebdesignonline.org