Optimisation

[Yatahonga]

Hi,

We have some optimisation problem : http://www.yatahonga.com/

We have :
2946 images in 28 categories for everyBody
AND :
5625 images in 39 categories for MEMBERS.

The HomePage give me :
Page generated in 10.674173 seconds with 12 queries, spending 6.196000 seconds doing MySQL queries and 4.478173 doing PHP things. GZIP compression disabled

How can have a Page generated in 3 seconds ?

Do I disable "Random image" section ?

thank's

Cyrille

[cisiodon]

I particulary using:

AdoDB writing Cache, and made index in others fields into MysQL. I have about 4000 images, and page generetade 3 or 4 seconds .

For those that want use AdoDB:

include("./pnadodb/adodb.inc.php");
 $ADODB_CACHE_DIR = 'drive:\\temp'; // for Win32
 $db = NewADOConnection('mysql');
 $db->Connect("yourhost", "usert", "pass", "Data_base_name");
 if (isset($cache)) $rs = $db->CacheExecute(120,'select * from nuke_modules');
 else $rs = $db->CacheExecute('select * from nuke_modules');


 if (isset($cache)) $rs = $db->CacheExecute(120,'select * from nuke_postwrap_url');
 else $rs = $db->CacheExecute('select * from nuke_postwrap_url');


 if (isset($cache)) $rs = $db->CacheExecute(120,'select * from nuke_blocks');
else $rs = $db->CacheExecute('select * from nuke_blocks');


 if (isset($cache)) $rs = $db->CacheExecute(120,'select * from nuke_xforum_forums');
else $rs = $db->CacheExecute('select * from nuke_xforum_forums');

 if (isset($cache)) $rs = $db->CacheExecute(120,'select * from nuke_xforum_posts');
else $rs = $db->CacheExecute('select * from nuke_xforum_posts');

 if (isset($cache)) $rs = $db->CacheExecute(120,'select * from nuke_xforum_threads');
else $rs = $db->CacheExecute('select * from nuke_xforum_threads');

while (!$rs->EOF) {
$rs->MoveNext();
}


This is an example working in Postnuke, and if you want use it in 4images, just change fields and insert into index.php..


Mike

[Yatahonga]

Thansk,

But what is "spending 6.196000 seconds" ???

Cyrille

[Yatahonga]

Thank's

It's a Delphi Application it works with a HTML form.
The POST data with this application into a Submit page.

It's not so hard.
All component exist :
http://www.indyproject.org/dowload/index.html
or ICS : http://overbyte.delphicenter.com/frame_index.html

Ask me, if you want more informations.

Cyrille

[Yatahonga]

What is a "bloody noob " ?

Of course I can write something about the uploader with source code
in Delphi and PHP.

I will try to make an extract the Week-end

Cyrille

[Yatahonga]

This is the SendImage function

procedure TFYatahonga.SendImage(user_id : string; direct_upload : string; cat_id : string;
                                media_file : string; thumb_file : string; image_name : string;
                                host : string; url : string);
var
  Source: TIdMultiPartFormDataStream;
begin
  Source := TIdMultiPartFormDataStream.Create;
  try
    Source.AddFormField('action', 'uploadimage');

    Source.AddFormField('user_id', user_id);
    Source.AddFormField('direct_upload', direct_upload);
    Source.AddFormField('cat_id', cat_id);
    Source.AddFormField('image_name', image_name);
    if media_file<>'' then
      begin
        Source.AddFile('media_file', media_file, 'image/jpeg');
        Source.AddFormField('dummy1', 'eof');
      end;
    if thumb_file<>'' then
      begin
        Source.AddFile('thumb_file', thumb_file, 'image/jpeg');
        Source.AddFormField('dummy2', 'eof');
      end;

    IdHTTPConnect.Post(host + url, Source);
  finally
    Source.Free;
  end;
end;

You can call them like this :
  SendImage(CfgUserId, cstdirect_upload, categorie, Nfile, NThumbFile, texte, cstHost, YatUrlUpload);

where CfgUserId, cstdirect_upload, categorie, Nfile, NThumbFile, texte, cstHost, YatUrlUpload are param in a WEB Form at the adress :
http://cstHost/YatUrlUpload

Soon

Cyrille

[tdkpaul]

wow this is very nice

i try it for my personal gallery