Author: Jose De Menezes Filho
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.
Reply: <http://www.mnogosearch.org/board/message.php?id=3039>
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
