Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

better search method?  RSS feed

 
Vijay Bhuruk
Ranch Hand
Posts: 31
MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi friends,

I am working on a application functionality for searching credit card details(card type, if issue number required, etc) for credit card number provided by user.

Custmomer will provide credit card number ranges for identifying these card details in CSV file format.

my question is,
should i directly search in CSV file for Credit card number or
store Rrecode from csv file into database like MS SQL server when application start and then search in database on customer request?

which one is better in performance . is there another way?

Regards,
Vijay

 
fred rosenberger
lowercase baba
Bartender
Posts: 12441
42
Chrome Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There are always other ways. Software design is all about balancing dozens of variables to find a solution that meets all your criteria. "Best" is a subjective word, as what you think is best is not the same as what I think is best.


How many records are you talking about? How much data is stored for each card? What are the customer requirements for response time? Will there be new data added often? Will existing data be changed often? What's your budget? What hardware do you have? Can you host a DB somewhere?

There are probably thousand more questions you need to think about before you settle on one specific design and implementation.
 
Vijay Bhuruk
Ranch Hand
Posts: 31
MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
fred, Thanks much for your guidance.

 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Far more important than performance in this case is security. You don't want to store your customers credit card information in plain text. It should be encrypted. One sure way to have your business go under is to have someone hack your system and get all of your customers addresses and credit card info.
 
Vijay Bhuruk
Ranch Hand
Posts: 31
MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Steve, Thanks much.

Actually, I am not storing customer's credit card details.

This database will store only IIN ranges for identifying type of credit card (for more info please see [edit] IIN ranges allocated to issuing networks)when user enters credit card number, my application will search for match in the table and return "CCType" i.e credit card type.

example, if user enter enter a credit card number that starts with 5018, application will return "Maestro".

Regards,
Vijay

 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!