more database help.

Id greatly apperciate (like you guys have always helped when I needed it). heres my full content of ecommerce, Id like to make a search engine like amazon.com where there is a pull down menu, and you can search from particular catagories my catagories are : (and there are many subcatagories)

1) Wheels/Tires
brands - 20 or so
2) Exterior
- body kits
-wings
-headlights
-taillights
-etc.
3) Interior
racing seats

4) Suspension/Brakes
air bags
coilovers
lowering springs
shocks
5) Performance
Intakes
Exhausts
Headers
NOS
Turbo Chargers
Super Chargers
6) Car Audio / Video
20 or so brands
ie
pioneer
jl audio
6) Accessories
battery tie down

what databases should I make for the search engine?
do i need to make a .aspx file that would retrieve this information?
if so, what info would I put in this file?
what relationships would the databases have?

2nd question -

to create a database for my product catalog / Shopping cart :

what databases do I create?
what type of relationships will they have?
is there a .aspx file that needs to be created?
if so, what info and where do I put it on the ftp?can anyone help me?

Monitoring/spying on the CE execution engine

Evening all,

I'm trying to do some profiling of a mobile application to determine where our performance bottleneck is. We have some conflicting information suggesting that inefficient usage of SqlCE might be the cause - but that code exists in a black-box library so we can't see what it's doing.

Are there any tools or configuration options to get the SqlCE execution engine to reveal what connections/queries it's being asked to perform? A simple list with some timestamps would be sufficient - just so we can map from our high-level data...

Any thoughts would be appreciated!
Jack

There is not a Profiler like the one you may use in SQL Server, however you can explore the execution plan that SQL CE's query procesor will use on any given query. Here's how: Connect to your SQL CE database from SQL Server 2005 Management Studio. Open a new query and then from the Query menu choose 'Display Estimated Execution Plan'.

Darren

sql