What a structure of the table?
Can you paste here command "CREATE TABLE ..."?

MartinJ

>I have a table in MySql with 140000 lines.
>
>If I try to create one view the command create view delay much time for shows it.
>
>If view in form places this (with noloaddata=.t. not to bring nothing), exactly thus it delays very to be constructed (same without data some only the structure).
>
>If delete everything data, view (also create view) all fast.