Re: DBI Efficiency

As chromatic mentioned - it depends, and without knowing more about your application it's really hard to say. Off-hand I'd wager that you are trying to optimize something that will only have very little effect on the actual run-time of your program - the difference between fetching one column and fetching four isn't likely to be hugely significant. If you have run-time problems they are likely to be elsewhere (such as incorrect indexes on the tables, or incorrect algorithms in your perl code)

Michael

Comment on Re: DBI Efficiency

Replies are listed 'Best First'.
Re: DBI Efficiency by Anonymous Monk on Jan 16, 2003 at 22:20 UTC
Thanks for the replies! Yeah sorry I should have gone into more detail :P I'm making a MUD, and the DB will contain all of the information about players, rooms, mobs, text, helps, objects....So I'll be using it a lot. Especially since for example during fighting hp can change by the second for multiple users. Just thought it would be a good idea to take the most efficient approach I could. On a completely unrelated topic, does anyone know how to make it not echo the password characters. All I can find out about is how to do it locally. Does the user's telnet client recognise a password line, or is there some special signal I need to send them or what? Thanks again, -- A frustrated llama.	[reply]
Re: Re: DBI Efficiency by mpeppler (Vicar) on Jan 16, 2003 at 22:47 UTC
I'm making a MUD, and the DB will contain all of the information about players, rooms, mobs, text, helps, objects....during fighting hp can change by the second for multiple users. I see. I still think you're starting your optimization at the wrong end. First make sure that your database design is efficient - it's the updates to the database that are likely to take most time and are likely to most affect the speed of the app (or at least that's been my experience...) Michael	[reply]