Re^3: OT: Scalable web application architecture


Think about Loose Coupling
	PerlMonks

Re^3: OT: Scalable web application architecture

by greywolf (Priest)

on Dec 07, 2005 at 16:09 UTC ( [id://514877]=note: print w/replies, xml )

Need Help??

in reply to Re^2: OT: Scalable web application architecture
in thread OT: Scalable web application architecture

I have some experience with an online reservation system.

You say that you have 1 database for each property, 400 in total with the same schema. It sounds like you should have all the properties in a single database. You can then link all your pricing, seasons and availablity etc to each property using your unique property id.

My guess is that you are getting slowed down with all the database connects required for each query. Plus you will be repeating the same query on each database (400 times ouch).

mr greywolf

Comment on Re^3: OT: Scalable web application architecture

Replies are listed 'Best First'.

Re^4: OT: Scalable web application architecture
by badaiaqrandista (Pilgrim) on Dec 07, 2005 at 23:48 UTC

That's how the database structure when I inherited the software. That's also why I created this 'search cache' thingy. I want to put all things in one table to speed up searching. But it becomes too overloaded with SELECT, INSERT, and UPDATE queries at the same time.

Changing the whole database structure is something I don't want to do right now because we don't have automated test that can give me security in mind.

[reply]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://514877]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others contemplating the Monastery: (2)

As of 2024-04-26 05:16 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found