SQL or Linking Tables ???

[mathew001]

If I have a table with 2 million rows and I just need values from 2 of columns, (of course based on some criteria) is there advantage of using a SQL query instead of Visual Linking Expert ?

 

[kenhamady]

If you only have one table there is no need for the visual linking expert. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[mathew001]

Hi Ken - How are you !
Should I use a query or read directly from table ?

 

[synapsevampire]

Just read from the table and select only the rows that you need, and make sure that you're able to pass the where criteria of the SQL through to the database (use Database->Show Sql Query to determine what's being passed).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[mathew001]

OK. I was wondering if there would be any perfomance
difference sql query over directly reading from table.

 

[kenhamady]

Probably not much difference but every environment is different. Why don't you try it both ways and tell us what you find? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[mathew001]

I shall try. This table is very big > 2 million rows !
Thanks Ken and synapsevampire !