Fixed,
Firstly the database has 316,011 records!
The program was a stupid mindographic error, I was using
"select * from blah where blah="string"" in mysql which worked kewl,
BUT! I had HAVING instead of WHERE in the perl program, changed it to a
WHERE instead of having and it works fine,
thanks Peter
Brock Stupid Henry
At 10:04 28/12/2000 +1100, you wrote:
>On Thu, 28 Dec 2000 09:06:17 +1100, Brock Henry wrote:
>
> >I have a database, with 50,000 or so records (not sure, don't know command
> >to check) and created an index on it "create index borrower_num on bhist
> >borrnum"
>
>select count(*) from table_name;
>
>
>[snip]
> >So it seems that the perl program isn't using the index.
> >Anyone got any ideas?
>
>Seems odd, if the query is the same, the method used to extract should
>be the same.
>
>Try the "EXPLAIN" statement in a perl script, it will tell you how the
>data is being extracted
>
>
>Regards
>
>
>
>--
>SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
>More Info: http://slug.org.au/lists/listinfo/slug
*************************************************************************
Brock Henry - [EMAIL PROTECTED] (H) - [EMAIL PROTECTED] (W)
Adventure? Excitement? A Jedi craves not these things.
*************************************************************************
--
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://slug.org.au/lists/listinfo/slug
