Board index » delphi » Midas application works slow with tables

2004-12-30 02:23:53 AM
delphi198
Hello,
I have Midas client/server application with MS SQL database.
When I am trying to get a table with more then 50000 records it takes about
5 minuts.
I use Socketconnection and ADO objects for this operation.
Can you help me to solve the problem?
Thanks
 

You should not be running a query that returns more than 100 rows. See
community.borland.com/article/0,1410,28160,00.html
--
Bill Todd (TeamB)
TeamB cannot answer questions received via email
 

stop using MS SQL it is already very slow itself
For midas You dont need a server database you may use flat database also
because with midas you are developping your own server that you can
manuplating freely. If you are looking for secure database than forget
MS SQL again because indexing problems if you dont beleive work and see.
use interbase or DbIsam they both fast and secure DbIsam has got encription
that it is very good.
With midas use Dcom or Corba connection method instead of sockhet use fetch
parametres method to elect data before client calls dont make any
master/detail relation on server make on client so you may decrease the
network traffic. if you do all you will love the midas. If you want to use
MS SQL that forget midas
"zion" <XXXX@XXXXX.COM>, haber iletisinde þunlar?
yazd?XXXX@XXXXX.COM...

That's fine, but really its all skirting around the issue. The real issue is
that it is very bad design to try to select 50,000 records. Don't do it.
There's always another way. Why could you possibly need all 50,000 in one
go. Process it in batches, or do smaller queries, select from an index of
the key fields and then pull the data records one at a time, build dynamic
SQL based on parameters, etc. etc..
"Mars" <XXXX@XXXXX.COM>writes

David Lewis writes:
have all the logic in the server anyway. This way the only thing that
needs to go across the line is the result (if any).