"Chris" <[EMAIL PROTECTED]> writes: > That's good to know. It's neither large nor volatile. 2.5k records at > most. What slows things down currently is that I do several evaluations > and JOINs on each record (to determine status of products and find > related data).
You'll benefit if you use VIEWs and correct indexes. Another thing to think about is using prepared statements instead of reissuing the same query over and over: as with VIEWs the planner can optimize this and choose a better approach to retrieve your data. The more you let the database server work, the less you'll "pay" in bandwidth and client side processing. > While going through the MochiKit examples I realized I can use > MochiKit.Async to, as they say, "facilitate the 'half a second' live > updating". So instead of doing a call (or paring down) on each > keystroke just wait a 1/2 or 1/4 second. That might almost completely > solve my speed issue. Also put some limit to the minimum amount of information you should have before you touch the database. For example, when using this to "auto search" the name of a client don't go to the database with just one character; instead wait for something like 3 or 4 letters to be typed and only then go retrieving something from the database. > Sorry. I should have mentioned that this is geared towards the > administration side. In the future it will be cool to roll this out to > customer side though. What doesn't make Bob's advice useless, since I believe you won't want everybody seeing how much each customer pays for your service... > I will be using LAMP. As in Linux, Apache, PostgreSQL and Python? ;-) Nice choice. :-) > That may be what I need to do. s/may be/is/ ;-) -- Jorge Godoy <[EMAIL PROTECTED]> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "MochiKit" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/mochikit -~----------~----~----~----~------~----~------~--~---
