Author: Alexander Barkov
Email: [EMAIL PROTECTED]
Message:
> Here is the table format:
>
> CREATE TABLE links (
> lid int(11) NOT NULL auto_increment,
> cid int(11) NOT NULL default '0',
> sid int(11) NOT NULL default '0',
> title varchar(100) NOT NULL default '',
> url varchar(100) NOT NULL default '',
> description text NOT NULL,
> date datetime default '0000-00-00 00:00:00',
> name varchar(100) NOT NULL default '',
> email varchar(100) NOT NULL default '',
> hits int(11) NOT NULL default '0',
> submitter varchar(60) NOT NULL default '',
> linkratingsummary double(6,4) NOT NULL default '0.0000',
> totalvotes int(11) NOT NULL default '0',
> totalcomments int(11) NOT NULL default '0',
> image varchar(10) default NULL,
> keywords varchar(255) default NULL,
> weight int(4) unsigned zerofill NOT NULL default '0000',
> PRIMARY KEY (lid),
> KEY url(url),
> KEY title(title),
> KEY cid(cid),
> KEY sid(sid)
> ) TYPE=MyISAM;
>
> ---end table format---
>
>
> We are testing the following HTDB virtual scheme:
>
>
> DBAddr mysql://user:password@localhost/database/
> DBMode crc-multi
>
> HTDBList SELECT
>concat("http://www.aonde.com.br/links.php?op=visit&lid=",lid) \
> FROM database.links
>
> HTDBDoc \
> SELECT concat( \
> 'HTTP/1.0 200 OK\\r\\n',\
> 'Content-type: text/html\\r\\n',\
> 'Last-Modified: ',Date_format(date,'%a, %d %b %Y %T'),' GMT\\r\\n',\
> '\\r\\n',\
> '<HTML><HEAD>',\
> '<TITLE>',title,'</TITLE>',\
> '<META NAME="Description" Content="',name,' ',url,'">',\
> '<META NAME="Keywords" Content="',keywords,'">',\
> '</HEAD>\\n',\
> '<BODY>\\n',description,'\\n</BODY></HTML>'\
> ) \
> FROM database.links \
> WHERE lid='$1'
>
> Server htdb:/
> Realm http://www.aonde.com.br/links.php?op=visit&lid=*
> Alias http://www.aonde.com.br/links.php?op=visit&lid= htdb:/
>
> ---end of virtual scheme---
>
> But "indexer" don't process more then 10000 entry each time, so I have to
>included a (LIMIT XXX, XXX ) on HTDBList command and re-run it several times changing
>LIMIT's XXX...
>
> "indexer" only run with -a option, so I can't do a incremental process
>indexing only the new entry appended.
>
You don't need to run indexer with -a for all links.
Only for a HTDBList. to collect new links. Use proper -u
limit.
Reply: <http://www.mnogosearch.org/board/message.php?id=3040>
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
