Hello Josh, JB> Not that you can't improve the query, just that it might not fix JB> the problem.
Yes, I'm aware it might be slower than the Linux version, but then, as you said, I still can improve the query (as I did with your help now). But true, if there's something awfully wrong with Win32 port performance, I might be doing some overwork... JB> Therefore ... your detailed feedback is appreciated, especially if you can JB> compare stuff to the same database running on a Linux, Unix, or BSD machine. I can't easily install Linux right now.. But I am considering using it through VMWare. Do you think it would suffice as a comprasion? From what I saw (e.g http://usuarios.lycos.es/hernandp/articles/vpcvs.html) the performance are bad only when it's coming to graphics, otherwise it looks pretty good. Regards, Vitaly Belman ICQ: 1912453 AIM: VitalyB1984 MSN: [EMAIL PROTECTED] Yahoo!: VitalyBe Wednesday, May 26, 2004, 7:17:35 PM, you wrote: JB> Vitaly, >> I am using the newer 7.5dev native Windows port. For this reason I >> don't think that IN will cause any trouble (I read that this issue was >> resolved in 7.4). JB> Well, for performance, all bets are off for the dev Windows port. Last I JB> checked, the Win32 team was still working on *stability* and hadn't yet even JB> looked at performance. Not that you can't improve the query, just that it JB> might not fix the problem. JB> Therefore ... your detailed feedback is appreciated, especially if you can JB> compare stuff to the same database running on a Linux, Unix, or BSD machine. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly