[AccessD] Search in AC2007 and SQL-Server

SQL Server will definitely be faster, but it really depends on what
you are returning.

How many fields are coming back? What type of fields are they? Are the
WHERE clause fields indexed?



On Fri, Nov 12, 2010 at 10:49 AM, Ralf Lister
<rlister at actuarial-files.com> wrote:
> Hello,
>
>
>
> Can someone give me a rule-of-thumb?
>
>
>
> Using the AC2007-database, for a table with 5 million records, how long a
> search for a particular record will take? Is the SQL-Server faster?
>
>
>
> TIA
>
>
>
> Saludos
>
> Actuary Ralf Lister
>
> La Paz, Bolivia
>
> Registrado en ASFI
>
> No. Registro: Act.Mat. 001
>
> NIT: 1016725022
>
> Skype Name: ralf.martin.lister
>
> Tel.: 222 26 61, Cel. 70136531
>
> rlister at actuarial-files.com
>
> www.actuarial-files.com
>
> Environment
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>