-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Umm.... Inserts shouldn't cause DB locking issues unless there were
updates or selects going on at the same time. If the table is just
used for logging, then locks should only be an issue when someone's
actually generating a report from the tables. And even then inserts
shouldn't clash with selects.
I don't think adding another layer would help matters any -- what's
the difference between calling OLEDB to do an insert vs. calling a
COM object to call OLEDB to do the insert? All that does is add
another layer that every page request has to wait on. It eats more
server RAM (*especially* the EJB), and just adds to the confusion.
Not that writing to the DB on every single page access is such a
*great* thing, but it shouldn't be *that* bad. If you are indeed
logging all request to the DB, you might try disabling the
webserver's logging capabilities to gain back some of what you're
losing to the DB.
Best regards,
Zac Bedell
>
> It sounds simple, but under tremendous load, your insert
> operations will
> probably cause locking issues and could drown the server.
>
> An EJB or COM object in the middle tier to receive this would
> probably be
> safer.
>
> The easiest thing to do is have a db with a table called
> logs, with the page
> name as the ID and increment this each time this page is
> called before the
> cflocation/cfinclude its that simple:-)
>
> I think fusebox is cool, but I've gotten myself in some hot
> water here... I
> created a nice application for a customer using fusebox.
> Now, they would
> like to get stat reports on it... well... because you're
> always going to the
> same page and including the others all of the stats come back as
> hits against the main index.cfm page, not the actual page that was
> hit.
>
> How on earth do I track these pages individually? How can I
> tell how many
> people looked at the contact page, or the support page or
> whatever??
>
> Thanks for any ideas...
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
iQA/AwUBObk0lQraVoMWBwRBEQLD+QCgn5CvxldbYvfAmCAhIUm3HD6EzKoAnR4X
BnnTBWXCbfKbBeM9soA+9r2r
=HQTG
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
