Em Sábado 24 Fevereiro 2007 19:45, Ingo Haase escreveu: > Please excuse the following question, but I grew up with TurboPascal > 3.0 on MS-DOS 3.1 where a single 10000x10000 array can cause serious > problems. > > > I am planning a project (ERP style) with one database, containing > 40-50 tables, each table has about 50 to 150 columns. > > Could that be a problem to TurboGears and SQLAlchemy, should I try an > other framework?
I dunno about the limits to SQLALchemy, but I believe that given enough RAM and CPU it will handle it. On the other hand, this looks like a normalization fault on your database project. You should try normalizing more and only denormalize in the end to get better performance after you've measured and optimized your queries. If you need several columns for one specific type of data, you might try using a database that supports arrays (e.g. for data collected from equipments). I'd say that you wouldn't have a problem with TG / SO or TG / SA, but you could get much better performance and lower your requirements for the app by rethinking the database design. Be seeing you, -- Jorge Godoy <[EMAIL PROTECTED]> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
