[aprssig] RE: findu.com and ui_view cgi suggestion

[Andrew Rich]

Ok then can you make me a raw cgi that will do more than one callsign ?

comma seperated should do it

http://www.findu.com/cgi-bin/raw.cgi?call=VK4KHP-9,w3ado-1,pcast-11,rs0iss

select * from raw where callsign in
("vk4khp-9","w3ado-1","pcast-11","rs0iss")





-----Original Message-----
From: Steve Dimse [mailto:steve at dimse.com]
Sent: Saturday, 30 July 2005 12:44 PM
To: Andrew Rich
Subject: Re: findu.com and ui_view cgi suggestion



On Jul 29, 2005, at 10:37 PM, Andrew Rich wrote:

> Can you make me a cgi VERY close to rawposit.cgi that matches on
> anything,
> not just the callsign please ?
>
> I want to replay all data in your database that matches "VK4GME-3"
> a local
> digi for example
>

No, the raw data is not indexed on free text because the index would
be prohibitively large for this 24 GB table. If you asked for all
packets in the last 24 hours that contained VK4GME-3, the only way
would be for the database to access each of those 1.4 million packets
and do the search. This would take a long time (upwards of 10
minutes), and since raw is a porous table, it would lock out writes
during the time it took to do this.

Steve K4HG