On 8/21/05, Jason Tackaberry <[EMAIL PROTECTED]> wrote: > On Sun, 2005-08-21 at 11:36 -0400, Jason Tackaberry wrote: > > Assuming indexed queries, it's the number of rows returned that matters, > > not the number of selects. A select which uses an indexed column which > > returns 0 rows is very, very fast. It's practically a no-op. >
> But at any rate, I think this convincingly demonstrates the > table-per-file-type, column-per-attribute approach is going to yield > appreciably better performance. I tested and looked your code, yes it is faster. Did you see mine? , there it's the other way around . funny how different views and use cases yield totally different tests ;). your-test: all static info from this directory. my-test:all dymanic info from this file. Martijn. ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ Freevo-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/freevo-devel
