Postby ConvertFromOldNGs » Fri Aug 07, 2009 11:45 am
by Tim Duggan >> Thu, 9 Dec 1999 22:06:18 GMT
Here's some raw data you might find interesting.
I just had a look at a couple of systems I implemented in the past. The following metrics were gathered using wc. I divided the sum from the db module in each case from the sum of all modules (.c files) in the app. The 'db' module in each case provides a database independent abstraction layer to perform insert, update, delete, and select/find of each 'persistent thang' used in the app.
1. C (OS/2) app to read data from a file and insert into SQL Server database. Based on lines of C code, 32% of the code was for database access.
2. C (Unix) app to read from Oracle database and pass data to client connected via a socket. Also based on lines of C code, 27% of code was for database access.
Although these apps aren't of an interactive nature, they give you an indication of the proportion of code that is necessary to access (map to) a relational database. Jade wouldn't require these db mapping modules.
I used to think half my code was db access, but it looks more like a third. Still a significant saving.
My 2c worth,
Tim Duggan