Is there any way for Magic xpa to use a native SQL Server connection instead of OleDb? For example, 20 queries with a OleDB SQL connection takes 18s, while same 20 Native SQL connection takes 10s (sam

#xpa #oledb #sql #performance

Hi everyone, in the example that came along with syncfusion installation there a sample of how to load large number of records into sfdatagrid in less than a second. If i lunch their example, it loads

#performance #sql #dotnet #xpa

Hi Adrian, it depends... What of Datatype in the SQL has this fiiled? Or waht is the xpa 'Stored as...' property? Nomally a small number is stored as integer (which is much bigger than those 2 digits)

#xpa #sql

Hello all again, i know restoring backups files from newer sql server into and older sql server doesn't work (ie backup was done in sql2019 and i need data in sql2017 ..). So in order for me to get th

#sql

Never used them. If we have speed issues we run the Tuning Advisor and let it do its thing if the improvement is “worth it”. Just checked, and it has never suggested a Clustered index. Steven Burrows

#xpa #sql