Honestly I don't think using "select <fieldlist>" or "select *" is a big speed difference - it's more like the ultimate fine tuning. I think dramatic results can be achieved by developing a table layout/imap logic that minimizes the number of queries and the amount of parsing done by the imap server.
On Tue, 2002-09-24 at 18:55, Ryan Butler wrote: > On Tue, 2002-09-24 at 10:48, Sam Przyswa wrote: > > > >Unless your program is getting back the rows as name value pairs and > > >picking > > through what gets sent back, you want to be specifying the columns and the > > order > > that they are to be sent back, not asking for everything and assuming that > > the > > order and number of the fields is what you think might be there. > > > > Sure it's easiest to SELECT named fields as SELECT * and use raw[x] to get > > the > > value. Our main goal it's to speed up DBmail and any suggestions are > > welcome ! > > > > That is not the easiest method, because unless you're getting it as an > associative array (name/val pairs, etc) Then you have no idea if raw[4] > is really what you expect on every installation (someone may have added > a field they need to the table). That is why the inserts and selects > only ask for the columns they need in the order they need. So that the > underlying table can be changed and not botch the whole system. > > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail
signature.asc
Description: This is a digitally signed message part
