Discussion:
speed problems accessing a 700,000 record database
(too old to reply)
Dinesh
2005-06-30 14:33:05 UTC
Permalink
hi,

I would appreciate if anybody has any tips on how to speed up browsing a
database with 700k records. the file structure of this database is mostly
having all character fields except for 2 fields which are of memo type.

for eg, when i do BROWSE FOR EMPTY(COUNTRY) it takes a while for the browse
window to come up and if later when i press pgup or pgdn it slows down again.

thanks in advance.

rgds,
dinesh
Fred Taylor
2005-06-30 15:11:39 UTC
Permalink
BROWSE and filtered conditions don't perform very well together. If it's a
read-only situation, use a SQL SELECT statement to get your condition before
doing the BROWSE on the resultant cursor. If you need to update the
records, you can use a parameterized view.
--
Fred
Microsoft Visual FoxPro MVP
Post by Dinesh
hi,
I would appreciate if anybody has any tips on how to speed up browsing a
database with 700k records. the file structure of this database is mostly
having all character fields except for 2 fields which are of memo type.
for eg, when i do BROWSE FOR EMPTY(COUNTRY) it takes a while for the browse
window to come up and if later when i press pgup or pgdn it slows down again.
thanks in advance.
rgds,
dinesh
Dinesh
2005-07-04 14:00:02 UTC
Permalink
Hi Fred,

Thanks for your suggestion.

I tried creating a View and then modified some data in the View. But when I
close the View and check in the actual dbf using BROWSE it does not reflect
the changes.

What do I need to do to allow to update my dbf after making any changes to
data in the View window.

Many thanks in advance.

Regards,
Dinesh
Post by Fred Taylor
BROWSE and filtered conditions don't perform very well together. If it's a
read-only situation, use a SQL SELECT statement to get your condition before
doing the BROWSE on the resultant cursor. If you need to update the
records, you can use a parameterized view.
--
Fred
Microsoft Visual FoxPro MVP
Post by Dinesh
hi,
I would appreciate if anybody has any tips on how to speed up browsing a
database with 700k records. the file structure of this database is mostly
having all character fields except for 2 fields which are of memo type.
for eg, when i do BROWSE FOR EMPTY(COUNTRY) it takes a while for the browse
window to come up and if later when i press pgup or pgdn it slows down again.
thanks in advance.
rgds,
dinesh
Fred Taylor
2005-07-04 16:53:04 UTC
Permalink
You have to check the box Send SQL Updates on the Update Criteria tab of the
View Designer. And since a View is buffered by definition, you have to do a
TABLEUPDATE() to send the changes in your view to the original table.
--
Fred
Microsoft Visual FoxPro MVP
Post by Dinesh
Hi Fred,
Thanks for your suggestion.
I tried creating a View and then modified some data in the View. But when I
close the View and check in the actual dbf using BROWSE it does not reflect
the changes.
What do I need to do to allow to update my dbf after making any changes to
data in the View window.
Many thanks in advance.
Regards,
Dinesh
Post by Fred Taylor
BROWSE and filtered conditions don't perform very well together. If it's a
read-only situation, use a SQL SELECT statement to get your condition before
doing the BROWSE on the resultant cursor. If you need to update the
records, you can use a parameterized view.
--
Fred
Microsoft Visual FoxPro MVP
Post by Dinesh
hi,
I would appreciate if anybody has any tips on how to speed up browsing a
database with 700k records. the file structure of this database is mostly
having all character fields except for 2 fields which are of memo type.
for eg, when i do BROWSE FOR EMPTY(COUNTRY) it takes a while for the browse
window to come up and if later when i press pgup or pgdn it slows down again.
thanks in advance.
rgds,
dinesh
Dinesh
2005-07-04 14:49:04 UTC
Permalink
Hi Fred,

Also, is there a command that can be typed in Command Window to "run" a SQL
View created.

Currently I have to do: MODIFY VIEW Myview and then right click to select
'Run Query'.

many thanks.
dinesh
Post by Fred Taylor
BROWSE and filtered conditions don't perform very well together. If it's a
read-only situation, use a SQL SELECT statement to get your condition before
doing the BROWSE on the resultant cursor. If you need to update the
records, you can use a parameterized view.
--
Fred
Microsoft Visual FoxPro MVP
Post by Dinesh
hi,
I would appreciate if anybody has any tips on how to speed up browsing a
database with 700k records. the file structure of this database is mostly
having all character fields except for 2 fields which are of memo type.
for eg, when i do BROWSE FOR EMPTY(COUNTRY) it takes a while for the browse
window to come up and if later when i press pgup or pgdn it slows down again.
thanks in advance.
rgds,
dinesh
Fred Taylor
2005-07-04 16:55:19 UTC
Permalink
If you simply type "USE yourviewname" in the Command Window, that will
execute your view. Then a simple BROWSE will show it to you. If your view
is already open and changes have been made on another workstation, you can
use REQUERY("yourviewname") to refresh the data.
--
Fred
Microsoft Visual FoxPro MVP
Post by Dinesh
Hi Fred,
Also, is there a command that can be typed in Command Window to "run" a SQL
View created.
Currently I have to do: MODIFY VIEW Myview and then right click to select
'Run Query'.
many thanks.
dinesh
Post by Fred Taylor
BROWSE and filtered conditions don't perform very well together. If it's a
read-only situation, use a SQL SELECT statement to get your condition before
doing the BROWSE on the resultant cursor. If you need to update the
records, you can use a parameterized view.
--
Fred
Microsoft Visual FoxPro MVP
Post by Dinesh
hi,
I would appreciate if anybody has any tips on how to speed up browsing a
database with 700k records. the file structure of this database is mostly
having all character fields except for 2 fields which are of memo type.
for eg, when i do BROWSE FOR EMPTY(COUNTRY) it takes a while for the browse
window to come up and if later when i press pgup or pgdn it slows down again.
thanks in advance.
rgds,
dinesh
Dinesh
2005-07-05 08:29:03 UTC
Permalink
many thanks.
regards,
dinesh
Post by Fred Taylor
If you simply type "USE yourviewname" in the Command Window, that will
execute your view. Then a simple BROWSE will show it to you. If your view
is already open and changes have been made on another workstation, you can
use REQUERY("yourviewname") to refresh the data.
--
Fred
Microsoft Visual FoxPro MVP
Post by Dinesh
Hi Fred,
Also, is there a command that can be typed in Command Window to "run" a SQL
View created.
Currently I have to do: MODIFY VIEW Myview and then right click to select
'Run Query'.
many thanks.
dinesh
Post by Fred Taylor
BROWSE and filtered conditions don't perform very well together. If it's a
read-only situation, use a SQL SELECT statement to get your condition before
doing the BROWSE on the resultant cursor. If you need to update the
records, you can use a parameterized view.
--
Fred
Microsoft Visual FoxPro MVP
Post by Dinesh
hi,
I would appreciate if anybody has any tips on how to speed up browsing a
database with 700k records. the file structure of this database is mostly
having all character fields except for 2 fields which are of memo type.
for eg, when i do BROWSE FOR EMPTY(COUNTRY) it takes a while for the browse
window to come up and if later when i press pgup or pgdn it slows down again.
thanks in advance.
rgds,
dinesh
Loading...