Re: [PERFORM] Index/Foreign Key Question

2003-10-10 Thread David Busby
- Original Message - From: "Ron Johnson" > On Fri, 2003-10-10 at 16:04, David Busby wrote: > > List, > > I'm creating this multi company POS database. > > My inventory table looks like (all items are unique): > > > > id,category_id,invoi

[PERFORM] Index/Foreign Key Question

2003-10-10 Thread David Busby
laced? Or since I have the FK setup are the indexes already in place? I expect to soon have >500K items in the inventory table and don't want it to slow down. I'll have the same type of issue with clients, invoices, purchase_orders and perhaps more Ideas? Thanks! David Busb