How to Protect & Safe a Large VFP Database

[COBART]

I Develope a Hospital Application. And I have table with 1.000.000 Record. When I procces and load data is very slow.

1. What I can do to fastest procces ?
2. How to protect Database VFP like SQL database ?
3. How to safety large table ?

Thanks,


Rudy [sig][/sig]

 

[foxdev]

You may be able to speed the processing by carefully adding new index tags. You should analyze your query statements and, along with some trial-and-error testing, determine which index tags will most improve performance. Create the index tags that give you the most performance improvement. Too many index tags may adversely affect your insert and update performance.

On the hardware side, more RAM may help (especially if you currently have 32Mb or less). [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[TomasDill]

1. Better organization of application queries - on the client side, better organization of database - at the server side. This is one of the main problems and purpose of RDBMS theory. On the server side use 3-d normalization form of database, as well as indexes like Robert mentioned. On the client side - its just programming on VFP. This very depended on the skill of programmers, tools you use, requirements to application, complexity to develop etc. In general, I know very little of situations in programming of client side when my application may delay for users more than for 5 seconds.
2. VFP do not have built-in security, like in SQL server. You may use third-party tools as well as Microsoft API for encryption.
3. How to safety large table
Not sure what you need here because spelling. When records added to VFP table, it automatically enlarged (I meant file size). When you need to add new column (field) to table - not a problem, but you require to open table in exclusive mode. To alter columns use 'ALTER TABLE' command. To open table in exclusive mode - 'USE MyTabe EXCLUSIVE'.
[sig]<p>Vlad Grynchyshyn<br><a href=mailto:vgryn@softserve.lviv.ua>vgryn@softserve.lviv.ua</a><br>[/sig]