>Dear Mark,
> Do you mean , when user logon we send parameter [userid or company id] to sql view for retrive or manipulate data? If I have about 60 million record in one table ,How is speed for retrive or update record.
>
>Regards,
>
>Sanit kiriwong.
I have no idea what your performance would be like retrieving records from a table that large. That is way beyond any scope I have ever done. If you have that many records, I would create a different schema for each company since each company will only be accessing their own data.
Mark McCasland
Midlothian, TX USA