Some time ago I was developing project what reports all action of user on web site. I hit big number of problems, mainly performance problem.…
Leave a CommentTag: SQL
I hit this need when I was developing own custom module into Commerce Server. Commerce Server have all tables separated into catalogs. Catalog is group of tables which contains records for particular client (site), but have same structure like all other catalogs. Lets say that we have two clients ‘Client1’, ‘Client2’. Each client has tables for products ‘Client1_Products’, ‘Client2_Products’. Now we can create two procedures for retrieving data from both tables or better we can create one procedure, which will have one input parameter – Catalog name.
Leave a CommentToday I found, that storing connection strings were little bit changed between .NET 2.0 and .NET 3.5. Here is an example of how to store…
5 CommentsIn the first part of this article I wrote about tree traversal database structure. Now I want to show you how to prepare all stored…
2 CommentsTree traversal is a systematic way of ordering the nodes of a tree. When you are going throw three traversal structure, you will visit each…
1 Comment