Hello, I'm new to MySql but have it all nicely working now, and I think it pretty much rocks :) 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" when I do a "select * from bhist where borrnum = "whatever"" from the mysql command line, it uses the index and takes less than one second to get the results. When I do it from a perl program, with "Use Mysql;" using the exact same select command, it takes about 10 seconds, which is about the time it took from the mysql command line before I created the index. So it seems that the perl program isn't using the index. Anyone got any ideas? ************************************************************************* 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
