INDEX build failed with errors: Generating INDEX-6 - please wait..pkg_info: not found pkg_info: not found Done. make_index: p5-Math-RPN-1.09: no entry for /nonexistentlocal/lib/perl5/site_perl/5.10.1/ExtUtils/MakeMaker.pm::/local0/portmgr/tindex/ports/devel/p5-ExtUtils-MakeMaker make_index: p5-Math-RPN-1.09: no entry for /nonexistentlocal/lib/perl5/site_perl/5.10.1/ExtUtils/MakeMaker.pm::/lo
Anthony wrote: I am trying to get rid of this loop and possibly use of logical indexing to make this more efficient. for i=1:length(Returns) if(Returns(i,:) 0) BothPos(i,1) = 1; else BothPos(i,1) = 0; end end BothPos = sum(BothPos); I have a matrix of returns "Returns". And I want to count only if both elements in each row are 0.
Around 80,000. I tried the ShowPlan bit a few days ago, but wasn't able to find the file that it supposedly creates, so I probably did something wrong. Also, I'm running this split over a network, with Access for both frontend and backend, so if I put a proper index on the backend, it might make a sizable difference in how fast it gets something from an extreme end, no? Pete "Jerry
I sometimes need to find the largest or smallest value in a field. If I put two indexes on the same field, one in ascending order and one in descending order, is Jet smart enough to use the proper index if a give it a grouping query with the condition Max or Min, or am I just wasting resources? Pete -- This e-mail address is fake, to keep spammers and their address harvesters out
On Jan 28, 8:59 am, "Peter H. Coffin" <hell...@ninehells.com> wrote: On Thu, 28 Jan 2010 02:09:11 -0800 (PST), Jason Carlton wrote: On Jan 28, 2:00 am, "Erick T. Barkhuis" <erick.use-...@ardane.c.o.m> wrote: Jason Carlton: I have 2 different scripts that query the same table. One script queries based on 3 columns, and the other queries based on 13 columns
