General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Speeding up queries, etc...
We have a large app that has tables of around 100mb. They are native VFP tables and are located on a shared drive on the server.
The problem is queries and such are slow because of the size of the tables. They have been optimized by creating indexes on the items that the queries are built on, etc...
If I understand correctly, the entire 100 mb tables are passed to the workstation for processing.
I believe I need to come up with a way to offload some of the processing to the server and just pass the results back.
Does this sound fesible??? Any suggestions on how to proceed with this?
We have actually considered to moving up to SQL Server. Would this be my best bet. It would mean almost a complete rewrite of about 40 megs of code.
Thanks in advance...
Tommy
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only